/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 vote249 views1 answer
Typescript record optional
TypeScript
1 vote253 views2 answers
View all foreign key constraints postgres
TypeScript
0 vote279 views1 answer
Tailwind base components utilities
TypeScript
0 vote284 views1 answer
Nested slots in vue
TypeScript
0 vote274 views2 answers
How to checka query to return User whose first name starts with R or last name starts with D in django
TypeScript
1 vote269 views1 answer
:= and = in gdscript
TypeScript
0 vote244 views1 answer
How to combine types in typescript
TypeScript
0 vote263 views1 answer
What kind of projects is suitable for the Agile methodology
TypeScript
0 vote277 views1 answer
Components of loadrunner
TypeScript
0 vote237 views1 answer
Import openzeppelin contracts in remix
TypeScript