/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 vote328 views1 answer
Ipywidgets hide widget
TypeScript
2 votes312 views1 answer
Requests python no proxy
TypeScript
3 votes362 views3 answers
C# check list of objects for value
TypeScript
1 vote346 views1 answer
Angular connexion
TypeScript
0 vote334 views2 answers
How to compare two entity objects in c# to update
TypeScript
2 votes345 views1 answer
How to call angular 8 form validation ngif
TypeScript
6 votes330 views1 answer
Angular devkit build angular error
TypeScript
0 vote326 views1 answer
Convert number to decimal in react typescript
TypeScript
0 vote301 views1 answer
Unity destroy all objects with tag
TypeScript
0 vote352 views1 answer
Difference between scripted testing and exploratory testing
TypeScript