/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 vote175 views3 answers
Convert typescript to js online
TypeScript
0 vote190 views1 answer
Vscode select between brackets ctrl+shift+m bracket-pair-colorizer-2.expandBracketSelection' not found
TypeScript
0 vote182 views1 answer
Create and use constants in angularjs
TypeScript
0 vote181 views1 answer
Ionic iosa app not making requests to server
TypeScript
55 votes497 views6 answers
How to get rid of bullet points in css
TypeScript
0 vote162 views1 answer
Pass class to generic typescript
TypeScript
0 vote172 views1 answer
Nativescript display image from web
TypeScript
0 vote190 views2 answers
Get string in brackets python
TypeScript
0 vote195 views1 answer
How to compare two lists and return the number of times they match at each index in python
TypeScript
1 vote220 views3 answers
Inbuild method to sum of an arraylist elements in java
TypeScript