/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 vote410 views1 answer
Angular 12 model class
TypeScript
13 votes370 views5 answers
Useref react typescript
TypeScript
0 vote329 views1 answer
Python unix get 5 minuts from now
TypeScript
9 votes339 views2 answers
React onclick typescript type
TypeScript
0 vote324 views1 answer
Typescript array to string
TypeScript
0 vote339 views1 answer
Depth-first search that chooses values for one variable at a time and returns when a variable has no legal values left to assign
TypeScript
2 votes348 views2 answers
Eslint no-unused-vars typescript
TypeScript
3 votes379 views3 answers
C# check list of objects for value
TypeScript
7 votes334 views2 answers
Conditional inline style angular
TypeScript
2 votes415 views1 answer
Expected 2 arguments but got 1. viewchild angular
TypeScript