/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 vote221 views1 answer
Jane and the Frost Giants "c++"
TypeScript
0 vote188 views1 answer
Flutter swiper page indicator
TypeScript
0 vote215 views1 answer
Display only user contributor comments wordpress
TypeScript
6 votes206 views1 answer
Comments pycharm
TypeScript
2 votes223 views1 answer
MySQL cheatsheets pdf download
TypeScript
0 vote213 views1 answer
Copying the contents of a file to another in terminal
TypeScript
-1 vote227 views1 answer
Create database if not exists mysql true spring boot
TypeScript
5 votes229 views1 answer
Close ports in windows
TypeScript
0 vote225 views1 answer
What do brackets mean in python
TypeScript
1 vote195 views1 answer
How to generate test data
TypeScript