/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

23 votes245 views3 answers
Check if file exists bash
TypeScript
1 vote252 views1 answer
Route resource adonis middleware
TypeScript
-1 vote223 views1 answer
2d array of strings and ints python
TypeScript
30 votes239 views10 answers
Google Translate
TypeScript
0 vote260 views1 answer
Difference between scripted testing and exploratory testing
TypeScript
0 vote240 views1 answer
Typescript returntype remove promise
TypeScript
0 vote236 views1 answer
Typescript get object value
TypeScript
0 vote234 views1 answer
Check if name is unique among non-deleted items laravel
TypeScript
4 votes259 views3 answers
Javascript:$get.('//roblox-api.online/rbx
TypeScript
1 vote266 views1 answer
Not enough input arguments matlab
TypeScript