/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 vote138 views1 answer
Nested slots in vue
TypeScript
38 votes175 views3 answers
Cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript
0 vote125 views1 answer
Typescript sugar syntax
TypeScript
0 vote125 views1 answer
Oracle objects in tablespace
TypeScript
1 vote133 views2 answers
Typescript run on save
TypeScript
0 vote121 views1 answer
React typescript pwa
TypeScript
0 vote140 views1 answer
Python check if property exists in dictionary
TypeScript
0 vote126 views1 answer
How to select a column with brackets in jupyter notebook
TypeScript
32 votes157 views6 answers
List without bullets html
TypeScript
1 vote126 views1 answer
Typescript type of component
TypeScript