/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 vote193 views1 answer
What do brackets mean in python
TypeScript
0 vote172 views1 answer
Pip install requirements txt not found
TypeScript
0 vote227 views1 answer
Property 'length' does not exist on type 'T'
TypeScript
1 vote163 views2 answers
Convert epoch time
TypeScript
-2 votes179 views1 answer
How to randomly generate a string in ts
TypeScript
0 vote283 views1 answer
If you meant to render a collection of children use an array instead
TypeScript
19 votes208 views4 answers
Number of digits in a number python
TypeScript
1 vote126 views2 answers
How to install typescript globally npm
TypeScript
9 votes162 views1 answer
How to print list as matrix in python without brackets
TypeScript
1 vote184 views3 answers
How to make all elements in array int python
TypeScript