/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 vote177 views10 answers
Javascript to typescript converter online
TypeScript
2 votes188 views1 answer
End to end testing vs unit testing
TypeScript
1 vote180 views1 answer
Typescript mix props
TypeScript
0 vote191 views1 answer
Error NG8001
TypeScript
0 vote193 views1 answer
Factory design pattern typescript
TypeScript
0 vote187 views1 answer
Highcharts turbothreshold not working
TypeScript
1 vote199 views6 answers
Swift constraints programmatically
TypeScript
2 votes234 views1 answer
Rror: failed to init transaction (unable to lock database) error: could not lock database: File exists if you're sure a package manager is not already running, you can remove /var/lib/pacman/db.lck
TypeScript
0 vote192 views1 answer
Get angular width
TypeScript
0 vote220 views2 answers
How to remove one object in an array of objects in mongoose
TypeScript