/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

1 vote282 views1 answer
React routes not working after build
TypeScript
0 vote311 views1 answer
Custom events in unity c#
TypeScript
1 vote316 views1 answer
Gets ents within range gmod lua
TypeScript
0 vote279 views1 answer
Bar plots subplots
TypeScript
1 vote286 views1 answer
Type 'MutableRefObject<undefined>' is not assignable to type 'RefObject<HTMLInputElement>'. Types of property 'current' are incompatible. Type 'undefined' is not assignable to type 'HTMLInputElement | null'. TS2322
TypeScript
2 votes291 views1 answer
Usedisclosure
TypeScript
0 vote302 views1 answer
Merge enum typescript
TypeScript
0 vote285 views1 answer
C code for insrting elements in set
TypeScript
0 vote276 views1 answer
Custom validation for phone-number using class-validator package
TypeScript
-1 vote239 views1 answer
Angular events list
TypeScript