/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 vote181 views1 answer
Mongoose get all documents big
TypeScript
0 vote161 views2 answers
Ixl ansers
TypeScript
0 vote152 views1 answer
Update multiple documents with different field value by id set. Mongoose
TypeScript
0 vote176 views1 answer
Cannot find module 'dotenv' or its corresponding type declarations
TypeScript
1 vote241 views3 answers
Stripe create subscription
TypeScript
10 votes153 views2 answers
Python get first n elements of list
TypeScript
0 vote150 views1 answer
Tensorflow 1.15 doesn't exists within pip instal
TypeScript
-1 vote150 views1 answer
Node scripts delay
TypeScript
0 vote146 views1 answer
Angular 6 checkbox checked dynamically
TypeScript
0 vote149 views1 answer
How does the biological aspect of mountain region depend upon its physical aspect
TypeScript