Typescript

Search

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

Comment

PREVIOUS	NEXT

Code Example
Typescript :: constructor interface typescript
Typescript :: change url param angular
Typescript :: typescript react dispatch
Typescript :: add digits java
Typescript :: an apparmor policy prevents this sender from sending this message to this recipient
Typescript :: what does virtual assistants do?
Typescript :: if shorthand typescript
Typescript :: ts declare function type
Typescript :: how many alphabets in english
Typescript :: ts log array to console
Typescript :: if image is broken show alternative image angular
Typescript :: disable sonar rule in code
Typescript :: find all running ports node
Typescript :: typescript check type of variable
Typescript :: Statement.executeQuery() cannot issue statements that do not produce result sets.
Typescript :: basic tsconfig file
Typescript :: how to pass arguments to filter function in python
Typescript :: google sheets mode text
Typescript :: making barplots in r
Typescript :: go through each element of a dictionary typescript
Typescript :: parameter passing in event emitter
Typescript :: pass data through router angular
Typescript :: difference between never and void in typescript
Typescript :: check if file exists on s3 python
Typescript :: components of cucumber bdd framework
Typescript :: typescript make object optional
Typescript :: run build dist in local angualr
Typescript :: check type of object typescript
Typescript :: css how to make a elements of same type start at same height
Typescript :: how to compile ts in cmd

Search

TYPESCRIPT

sheets column number to letter

ADD CONTENT