/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

5 votes217 views2 answers
Typescript css variables html
TypeScript
1 vote198 views1 answer
Advantages of automation
TypeScript
0 vote227 views2 answers
Linux bash scripts tutorial
TypeScript
0 vote218 views1 answer
React onclick action starts automatically
TypeScript
0 vote192 views1 answer
How to get docker stats using shell script
TypeScript
0 vote225 views1 answer
Swift collection view deselects item when scroll off screen
TypeScript
0 vote204 views1 answer
Angular Workspace
TypeScript
0 vote208 views1 answer
When new item added in array its not refreshing the list in ember
TypeScript
1 vote183 views1 answer
Dispatcher servlet as its web application context
TypeScript
1 vote269 views1 answer
Google sheets concatenate
TypeScript