/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

7 votes163 views3 answers
Mongo count elements in array
TypeScript
1 vote180 views2 answers
Measurement technique of total fiber attenuation gives
TypeScript
1 vote143 views1 answer
Laravel update if exists or create
TypeScript
1 vote180 views1 answer
Execute only one test spec with angular-cli (ng test)
TypeScript
0 vote158 views1 answer
Many plants obtain glucose through the process of ----
TypeScript
9 votes204 views5 answers
Python requests use proxy
TypeScript
56 votes389 views4 answers
How to see all the environments in Conda
TypeScript
0 vote142 views1 answer
Export of name 'matMenu' not found!
TypeScript
0 vote146 views1 answer
Push and array of objects to firebase
TypeScript
0 vote149 views1 answer
Rails flags for tests assets and helpers
TypeScript