/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 vote310 views1 answer
Hop shoots uses
TypeScript
1 vote313 views1 answer
Handling ajax requests in django
TypeScript
0 vote290 views1 answer
Type script encode url
TypeScript
0 vote312 views1 answer
Copy contents of multiple files to one file powershell
TypeScript
1 vote295 views1 answer
Angular typescript set meta data
TypeScript
0 vote307 views1 answer
Replace element in array typescript
TypeScript
2 votes300 views1 answer
Vscode custom snippets how to use file name
TypeScript
0 vote293 views1 answer
Pandas get count of pair of elements in two columns
TypeScript
0 vote295 views1 answer
Angular dictionary
TypeScript
2 votes306 views1 answer
Loaded because running scripts is disabled on this s
TypeScript