/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 vote285 views3 answers
An attempt was made to access a socket in a way forbidden by its access permissions
TypeScript
1 vote275 views1 answer
React link state
TypeScript
0 vote248 views1 answer
Use strict typescript
TypeScript
0 vote262 views1 answer
Add key value pair to all objects in array
TypeScript
0 vote254 views2 answers
Sum the digits in c
TypeScript
7 votes269 views3 answers
Ts await foreach loop
TypeScript
0 vote288 views1 answer
FIFA 21 esports temas
TypeScript
1 vote282 views1 answer
Ionic modalcontroller No component factory found for Did you add it to
TypeScript
0 vote265 views1 answer
Two sets of parentheses after function call
TypeScript
34 votes318 views4 answers
Google fonts roboto
TypeScript