/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 vote260 views1 answer
Multicolor points in one legend entry python
TypeScript
0 vote195 views1 answer
React forwardref typescript
TypeScript
1 vote172 views1 answer
A function that prints all numbers from 0 - n Added together python
TypeScript
9 votes249 views2 answers
Mongodb add array to set
TypeScript
0 vote178 views1 answer
How to validate if all characters enetred in a string are alphabets and then reprompt user
TypeScript
0 vote209 views1 answer
Sql concepts interview questions
TypeScript
0 vote174 views2 answers
Gradients colors in android
TypeScript
2 votes160 views2 answers
Remove all the elements from a numpy array python
TypeScript
0 vote163 views2 answers
Sum the digits in c
TypeScript
7 votes300 views2 answers
React native typescript template
TypeScript