/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

-1 vote135 views2 answers
React-helmet typescript
TypeScript
0 vote164 views1 answer
FIFA 21 esports temas
TypeScript
8 votes139 views3 answers
Showing 2 digits of float in python
TypeScript
2 votes135 views1 answer
Cannot find module 'next' or its corresponding type declarations.
TypeScript
2 votes143 views2 answers
Constraints in database
TypeScript
1 vote143 views1 answer
Require statement not part of import statement.eslint@typescript-eslint/no-var-requires
TypeScript
0 vote141 views1 answer
Merge enum typescript
TypeScript
0 vote127 views1 answer
Formatting to six digits in python
TypeScript
0 vote139 views2 answers
Comparison method violates its general contract!
TypeScript
0 vote134 views1 answer
Multiple generic constraints c#
TypeScript