/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 vote344 views1 answer
Ipywidgets hide widget
TypeScript
2 votes329 views2 answers
Change material ui appbar color
TypeScript
1 vote322 views1 answer
Js split at index
TypeScript
22 votes332 views2 answers
React native typescript children prop
TypeScript
6 votes325 views3 answers
Angular show element in component
TypeScript
1 vote329 views1 answer
Typescript array of react elements
TypeScript
5 votes334 views3 answers
How to reload same page in angular 8
TypeScript
0 vote313 views1 answer
Check restore percentage tsql
TypeScript
0 vote363 views1 answer
FIFA 21 esports temas
TypeScript
0 vote426 views2 answers
Rails precompile assets production
TypeScript