/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

18 votes286 views6 answers
If table exists drop
TypeScript
0 vote321 views1 answer
Loop trhough list of lists in python and find single elements
TypeScript
0 vote261 views2 answers
Paths typescript
TypeScript
0 vote251 views1 answer
React native type png
TypeScript
1 vote274 views1 answer
Ts playground download
TypeScript
0 vote268 views1 answer
Google map Argument of type 'HTMLElement | null' is not assignable to parameter of type 'Element'
TypeScript
0 vote276 views1 answer
CUSTOM_ELEMENTS_SCHEMA error occur while unit testing with jasmine and karma
TypeScript
-2 votes323 views5 answers
Could not find a declaration file for module 'module-name'. '/path/to/module-name.js' implicitly has an 'any' type
TypeScript
0 vote274 views1 answer
'platformNativeScriptDynamic' is deprecated
TypeScript
-1 vote277 views1 answer
ResultSet object has no attribute 'get_text'. You're probably treating a list of elements like a single element. Did you call find_all() when you meant to call find()?
TypeScript