/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 vote305 views1 answer
Adding API request
TypeScript
1 vote326 views1 answer
Kotlin version that is used for building with gradle
TypeScript
1 vote366 views1 answer
React typescript cheat sheet
TypeScript
0 vote297 views1 answer
How to separate real and imaginary parts of a complex number in python
TypeScript
0 vote313 views1 answer
UpdateTable operation with the GlobalSecondaryIndexUpdates parameter
TypeScript
0 vote308 views1 answer
Embed youtube search results into website
TypeScript
2 votes333 views2 answers
How to close all ports angular
TypeScript
0 vote304 views1 answer
Regex exec returns null
TypeScript
1 vote305 views1 answer
How do i remove the brackets around a list in python
TypeScript
1 vote295 views1 answer
Matlab run all tests in folder
TypeScript