/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 vote217 views1 answer
Typescript dynamic array key
TypeScript
23 votes256 views3 answers
Check if file exists bash
TypeScript
0 vote300 views1 answer
Type alias in typescript
TypeScript
3 votes262 views1 answer
Ts reverse array
TypeScript
-1 vote253 views3 answers
Lodash merge array of objects without duplicates
TypeScript
0 vote237 views1 answer
Discord bot login
TypeScript
2 votes233 views2 answers
Organize imports on save vscode
TypeScript
1 vote267 views1 answer
Javascript audio delay
TypeScript
7 votes326 views3 answers
Module was compiled with an incompatible version of kotlin. the binary version of its metadata is 1.5.1, expected version is 1.1.16.
TypeScript
3 votes236 views3 answers
How to get value from autocomplete material ui
TypeScript