/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

10 votes236 views2 answers
Add class to all child elements jquery
TypeScript
0 vote180 views9 answers
Twitter analysis in R clean tweets
TypeScript
2 votes195 views1 answer
Router navigate pass params
TypeScript
0 vote192 views1 answer
Convert int number in f#
TypeScript
0 vote225 views1 answer
Python select only first elements of a 2d array
TypeScript
17 votes210 views3 answers
Js null ==
TypeScript
0 vote191 views1 answer
Laravel many to many get related posts by category
TypeScript
0 vote212 views1 answer
Check if file exists on s3 python
TypeScript
84 votes520 views6 answers
Conda list environments
TypeScript
0 vote214 views1 answer
How to put column value counts into a histogram
TypeScript