/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

10 votes296 views1 answer
Keras cheatsheets pdfs
TypeScript
1 vote277 views1 answer
Angular host binding class on input
TypeScript
1 vote280 views1 answer
Array of object react js useState
TypeScript
-2 votes342 views5 answers
Could not find a declaration file for module 'module-name'. '/path/to/module-name.js' implicitly has an 'any' type
TypeScript
1 vote272 views1 answer
Benefits eat halim plant leaves
TypeScript
1 vote282 views1 answer
Drop index if exists mysql
TypeScript
0 vote270 views2 answers
Get elements of array matlab
TypeScript
1 vote257 views1 answer
District affected by latur earthquake
TypeScript
4 votes284 views3 answers
Flutter unfocus textfield
TypeScript
1 vote278 views1 answer
Promise.all does not wait
TypeScript