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.
All of the examples illustrated in this article were performed using Microsoft Excel 2016 for Windows.
“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.