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...
If you want to omit - for example - the first 3 and last 2 characters:
=MID(A1, 4, LEN(A1)-3-2)