/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 vote227 views1 answer
How to collect array of objects in one value key in laravel
TypeScript
2 votes201 views2 answers
Typescript datetimte
TypeScript
1 vote175 views1 answer
Count items in list applescript
TypeScript
0 vote181 views1 answer
Make foreign key sql in exists row
TypeScript
1 vote199 views1 answer
Serenity Criteria typescript
TypeScript
0 vote199 views2 answers
Django query to return User whose first name starts with j or last name starts with h
TypeScript
0 vote183 views1 answer
Get-dirstats not recognized
TypeScript
0 vote200 views1 answer
"Listed following are distinguishing characteristics of different end states of stars. Match these to the appropriate consequence of stellar death."
TypeScript
3 votes199 views1 answer
Angular material button css not working
TypeScript
1 vote215 views1 answer
Vue router mode history typescript
TypeScript