Tip for beginners: Remove first & last characters from text
You might be familiar with the LEFT & RIGHT functions, which always take a fixed number of characters from the left or right side of a piece of text.
However, if you want to remove a fixed number of characters this doesn’t work, so we have to make it more dynamic with the LEN function.
The LEN function gives you the number of characters a piece of text has.
So when we put it all together you can use this function, to remove the first 3 characters from a piece of text:
=RIGHT(A1, LEN(A1) – 3)
I also made a video with some more examples: https://www.youtube.com/watch?v=J3TNjJEvkMY
Do you know any other ways to get the same result? Perhaps easier or more robust?
You might be familiar with the LEFT & RIGHT functions, which always take a fixed number of characters from the left or right side of a piece of text. However, if you want to remove a fixed number of characters this doesn’t work, so we have to make it more dynamic with the LEN function. The LEN function gives you the number of characters a piece of text has. So when we put it all together you can use this function, to remove the first 3 characters from a piece of text:=RIGHT(A1, LEN(A1) – 3) I also made a video with some more examples: https://www.youtube.com/watch?v=J3TNjJEvkMY Do you know any other ways to get the same result? Perhaps easier or more robust? Read More