/TypeScript/Google sheets remove first character

Google sheets remove first character

Google sheets remove first character

Using the RIGHT Formula
=RIGHT(A2, LEN(A2)-1)

Using the MID Formula
=MID(A2,2,LEN(A2)-1)

Using the REPLACE Formula
=REPLACE(A2,1,1,"")

3

Source: spreadsheetpoint.com

Similar codes

0 vote271 views1 answer
Regular expression starts and ends with same symbol
TypeScript
0 vote284 views1 answer
Welsh cup electrodes have
TypeScript
0 vote296 views2 answers
"Type error: ReflectionFunction::__construct() expects parameter 1 to be string, array given"
TypeScript
0 vote291 views1 answer
Flutter fab covers widget on keyboard open
TypeScript
7 votes287 views2 answers
Axios typescript
TypeScript
0 vote279 views1 answer
Are flights still running
TypeScript
0 vote284 views1 answer
Dynamic key interface typescript
TypeScript
0 vote285 views1 answer
Execution failed for task ':app:lint'. > Lint infrastructure error
TypeScript
0 vote280 views1 answer
Compare two objects deep
TypeScript
0 vote266 views1 answer
How to pass data to another page in ionic 3
TypeScript

Share