/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 vote261 views2 answers
_swapbatch.foreach multiple statements c#
TypeScript
3 votes271 views2 answers
Foreach on dictionary in typescript
TypeScript
0 vote252 views1 answer
How to check if key exists in Newtonsoft.Json object c#
TypeScript
-3 votes227 views1 answer
How do we write comments in myql
TypeScript
0 vote230 views1 answer
Install vsts client version 14.102.0
TypeScript
0 vote261 views1 answer
How to git pull all projects in a folder
TypeScript
-1 vote248 views1 answer
Typescript http get attach headers
TypeScript
1 vote246 views1 answer
Rscript arguments input
TypeScript
1 vote252 views1 answer
How to configure email alerts in grafana container
TypeScript
0 vote243 views1 answer
How to display dotted line betweens 2 series point in high charts react native
TypeScript