/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 vote216 views1 answer
Get angular width
TypeScript
0 vote213 views1 answer
Res.write prints html tags as text in express
TypeScript
0 vote203 views1 answer
Java delete contents of file
TypeScript
1 vote217 views1 answer
How to configure email alerts in grafana container
TypeScript
0 vote213 views1 answer
How to check typescript version for my react-app
TypeScript
0 vote171 views1 answer
Echo contents of file to another file
TypeScript
0 vote209 views1 answer
How do you check ewhich version of typescript you are using
TypeScript
1 vote213 views1 answer
Angular typescript set meta data
TypeScript
0 vote208 views1 answer
On select date matpicker angular
TypeScript
0 vote193 views1 answer
Helpppppp!!!...........
TypeScript