/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 votes108 views2 answers
Organize imports on save vscode
TypeScript
0 vote109 views2 answers
Add redux to react typescript
TypeScript
0 vote98 views1 answer
Remove all objects in R
TypeScript
1 vote115 views1 answer
Cannot read property 'slideTo' of undefined TypeError: Cannot read property 'slideTo' of undefined
TypeScript
1 vote150 views3 answers
Where do you get your test data
TypeScript
4 votes108 views2 answers
Ionic toast animation
TypeScript
16 votes105 views2 answers
Chunk list python
TypeScript
0 vote117 views1 answer
Typescript assert non null
TypeScript
0 vote119 views1 answer
Typescript iterate over interface
TypeScript
0 vote108 views1 answer
Cannot find module '@azure/msal-angular' or its corresponding type declarations.ts(2307)
TypeScript