Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Take Off One Character

remove character google sheets
Google Sheets: Take Off One Character

remove character google sheets

Remove the Leading Character

I sometimes have a need to extract part of word or text string when using a spreadsheet. For example if I have a hashtag in my spreadsheet #googlesheets and I want to create a clickable hyperlink, the link does not like the hashtag # symbol.

=LEN()

The first formula you might want to use is =len() which counts the number of characters in a cell. For example if you have #googlesheets in cell B1 then using =len(B1) will return 13.

=RIGHT()

The formula =right() returns the specified number of characters from the right. For example if #googlesheets is in cell B1 then =right(B1,3) returns ets.

Together

Use these 2 formulas together (plus a little of your algebra skills). You want the number of characters minus the first character. So if #googlesheets is in cell B2 then =right(B2, len(B2)-1) will return googlesheets.
google sheets right and length remove a character

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.