/TypeScript/Sheets column number to letter

Sheets column number to letter

SUBSTITUTE(ADDRESS(1,column number,4),"1","") turns a column number into a letter
	SUBSTITUTE(ADDRESS(1,2,4),"1","") gives B

ADDRESS(1,column number,4) turns two values into an address
	ADDRESS(1,2,4) gives B1
    ADDRESS(2,1,4) gives A2
    ADDRESS(2,1,1) gives $A$2
    
SUBSITUTE(address,"1", "") subsititutes the "1" with "", removing it.
	SUBSITUTE(B1,"1", "") gives B

Similar codes

0 vote97 views1 answer
Google sheets add all numbers in a column with condition
TypeScript
0 vote95 views1 answer
How to round float to 2 decimal places
TypeScript
0 vote127 views1 answer
What are the common mistakes in software development
TypeScript
1 vote113 views1 answer
Remove contraints command psql
TypeScript
0 vote59 views1 answer
Import luno pricing to google sheets api
TypeScript
0 vote103 views1 answer
How to set date axes limits in matplotlib plot
TypeScript
1 vote120 views1 answer
Not enough input arguments matlab
TypeScript
0 vote99 views1 answer
Template matching several bounding boxes outputted need only one
TypeScript
0 vote95 views1 answer
How to add new row to a particular index of a ag grid using angular 7
TypeScript
0 vote102 views1 answer
Change field name relation typeorm
TypeScript