/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

26 votes216 views2 answers
List commits in git
TypeScript
2 votes225 views1 answer
Powersell execution policy
TypeScript
0 vote233 views1 answer
S'entrainer pour tests techniques developpeurs web
TypeScript
12 votes244 views3 answers
Python count number of digits in integer
TypeScript
0 vote258 views1 answer
What are the common mistakes in software development
TypeScript
0 vote210 views1 answer
Ts console.log
TypeScript
0 vote218 views1 answer
How to add space between inputs in a text file python
TypeScript
0 vote223 views1 answer
Are remote objects and distributed objects the same
TypeScript
0 vote179 views1 answer
Terrform variable list type
TypeScript
0 vote218 views1 answer
Object notation string javascript\
TypeScript