/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

26 votes145 views3 answers
How to install typescript in windows 10
TypeScript
4 votes118 views2 answers
Cannot find module .svg' or its corresponding type declarations.
TypeScript
0 vote126 views1 answer
.htaccess Preventing requests with invalid characters
TypeScript
0 vote115 views1 answer
Reach router path typescript error
TypeScript
6 votes120 views4 answers
Console
TypeScript
9 votes112 views2 answers
Array contains typescript
TypeScript
0 vote133 views1 answer
Pull rewuests in local project
TypeScript
1 vote118 views1 answer
React typescript custom hook
TypeScript
6 votes112 views1 answer
Typescript dictionary typing
TypeScript
-1 vote134 views1 answer
Create database if not exists mysql true spring boot
TypeScript