/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

1 vote177 views2 answers
Downloading youtube playlists using youtube-dl in highest quality
TypeScript
0 vote164 views1 answer
Do you use data structures in your current automation project
TypeScript
0 vote172 views1 answer
Google chrome keyboard shortcuts windows
TypeScript
0 vote205 views1 answer
How to register a static assets folder spring boot
TypeScript
0 vote214 views1 answer
Making barplots in r
TypeScript
26 votes218 views3 answers
Scripts cannot be executed on this system.
TypeScript
0 vote187 views1 answer
Google sheets add all numbers in a column with condition
TypeScript
0 vote183 views1 answer
Modify the program so it also prints the number of A, T, C, and G characters in the sequence in python
TypeScript
1 vote176 views1 answer
Nextjs waiting for compilation error
TypeScript
30 votes172 views3 answers
Set number of decimals python
TypeScript