/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 vote343 views1 answer
Disable pdf download button in iframe in angular 10
TypeScript
1 vote318 views1 answer
React native Error styled 'marginTop' of RCTView with JSON value 'px' of type NSString
TypeScript
1 vote316 views1 answer
Adonisjs decrement
TypeScript
2 votes308 views1 answer
Google Sheets How to Count business Days Between Two Dates
TypeScript
1 vote376 views1 answer
'mat-label' is not a known element:
TypeScript
0 vote324 views1 answer
After effects how to parent only one property
TypeScript
0 vote367 views1 answer
Function in c that converts current time in timezone
TypeScript
2 votes409 views2 answers
Get documents path c#
TypeScript
0 vote339 views1 answer
Python append elements from one list to anoter
TypeScript
-1 vote340 views2 answers
Sort array elements in descending order based on object key
TypeScript