/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

25 votes103 views10 answers
Bootstrap
TypeScript
11 votes110 views5 answers
Get query params from url angular
TypeScript
0 vote107 views1 answer
Module '"@angular/fire/firestore"' has no exported member 'AngularFirestoreDocument'
TypeScript
0 vote114 views2 answers
Filtering objects in django templates
TypeScript
1 vote96 views1 answer
Typescript json.parse
TypeScript
0 vote114 views1 answer
IM DEAD
TypeScript
0 vote116 views1 answer
IC markets minimum deposit
TypeScript
5 votes120 views2 answers
Typescript css variables html
TypeScript
0 vote108 views4 answers
Craeting a method that can take any number of arguments in python
TypeScript
7 votes109 views3 answers
How to make a rounded button
TypeScript