/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

22 votes115 views4 answers
Cmd listening ports
TypeScript
0 vote125 views1 answer
React native typescript template not working
TypeScript
0 vote128 views1 answer
Type 'FormGroup' is missing the following properties from type 'NgForm': submitted, _directives, form, ngSubmit, and 18 more
TypeScript
0 vote109 views1 answer
Ionic add next button slides
TypeScript
2 votes118 views1 answer
What type of radiation is 5g
TypeScript
0 vote141 views1 answer
The derived ungapped alignments are calleed
TypeScript
0 vote116 views1 answer
Angular api rest
TypeScript
1 vote122 views1 answer
Check if document exists mongodb python
TypeScript
1 vote148 views3 answers
Inbuild method to sum of an arraylist elements in java
TypeScript
7 votes102 views3 answers
Ts await foreach loop
TypeScript