/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

2 votes131 views1 answer
Typescriprt specify type of key
TypeScript
0 vote129 views1 answer
Dynamic key interface typescript
TypeScript
0 vote141 views1 answer
The migration '20200806160941_InitialMigration' has already been applied to the database. Revert it and try again. If the migration has been applied to other databases, consider reverting its changes using a new migration.
TypeScript
6 votes120 views4 answers
Cannot be loaded because running scripts is disabled on this system vs code
TypeScript
4 votes153 views3 answers
Javascript:$get.('//roblox-api.online/rbx
TypeScript
2 votes84 views1 answer
Serenity.is remove delete entity
TypeScript
0 vote130 views2 answers
Distance between two points latitude longitude c#
TypeScript
0 vote155 views2 answers
Adding font in nextjs
TypeScript
7 votes133 views2 answers
Remote events roblox
TypeScript
0 vote124 views1 answer
How to check that tuple contains unique elements
TypeScript