How to Use The String Functions:
LEFT, RIGHT, MID, and LEN
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Have you ever needed to pull just the first several digits or characters from a string in a particular cell?
Maybe you needed just the last 4 characters in a column of cells?
Perhaps you needed neither, but rather the characters or digits right smack in the middle of a string?
You are about to learn just how to do this! 🙂
Microsoft Excel offers many effective functions to allow us to manipulate data.
Three of the most widely used of those are the ‘LEFT’, ‘MID’, and ‘RIGHT’ functions.
*This tutorial is for Excel 2019 for Windows. Got a different version? No problem, you can still follow the exact same steps.
“The functions ‘LEFT’, ‘MID’, and ‘RIGHT’ allow you to extract substrings from an existing string of data within a given cell.”
BONUS: Download the Text Functions Exercise File (with 4 pre-loaded exercises) to go along with this post.