/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 vote147 views1 answer
UTorrent Default Download Folder - Linux
TypeScript
1 vote176 views2 answers
How to remove last 2 elements from list in python
TypeScript
0 vote150 views1 answer
Behaviour
TypeScript
14 votes146 views6 answers
Find the smallest number from an array
TypeScript
0 vote166 views1 answer
Google sheets countif two conditions
TypeScript
1 vote175 views1 answer
Adonisjs hooks
TypeScript
1 vote148 views3 answers
Linux split mp4 into 2 parts by time
TypeScript
1 vote167 views2 answers
React-scripts
TypeScript
0 vote146 views1 answer
Cannot find name 'describe'. Do you need to install type definitions for a test runner? Try `npm i --save-dev @types/jest`
TypeScript
2 votes191 views1 answer
Ionic save base64 as file
TypeScript