/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 vote191 views1 answer
Nestjs get request header in guard
TypeScript
2 votes205 views2 answers
Constraints in database
TypeScript
0 vote166 views1 answer
When to test analysis
TypeScript
0 vote191 views1 answer
Convert c# class to typescript
TypeScript
0 vote190 views1 answer
Get_refreshed_fragments too long to load
TypeScript
0 vote182 views3 answers
Woocommerce remove This is where you can add new products to your store in taxonomy description
TypeScript
0 vote223 views1 answer
Test if parameter supports null reflection
TypeScript
0 vote218 views4 answers
C++ sort vector of objects by property
TypeScript
0 vote176 views2 answers
Ng2003
TypeScript
7 votes176 views2 answers
Conditional style angular
TypeScript