/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 vote147 views1 answer
Size of list applescript
TypeScript
0 vote140 views2 answers
How to invert sortField primeng
TypeScript
0 vote134 views1 answer
Angular viewchild second parameter
TypeScript
0 vote136 views2 answers
Typescript omit
TypeScript
1 vote131 views1 answer
What is typescript in angular
TypeScript
0 vote156 views1 answer
Python append elements from one list to anoter
TypeScript
0 vote139 views1 answer
Exposants python
TypeScript
1 vote135 views1 answer
Python all elements in list in another list
TypeScript
0 vote139 views1 answer
Call appply bind
TypeScript
1 vote151 views1 answer
Aws sqs create fifo queue
TypeScript