Forum Discussion
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...
Another way to omit the first 3 characters is to use the MID function:
=MID(A1, 4, 1000)
The 1000 is just an arbitrary number greater than the expected length of the cell value. If you are certain that A1 will never have more than 10 characters, you could use
=MID(A1, 4, 7)
That's a creative approach especially, since it only requires one function.