Extracting text strings in Excel using ‘=LEFT()’, ‘=RIGHT()’ and ‘=MID()’

Let’s take a well-known phrase: The cat sat on the mat. Below are 3 examples using ; ‘=LEFT()’, ‘=RIGHT()’ and ‘=MID()’ and the results. These formula’s can be extremely useful for things like separating first and last names in cells, or splitting postcodes or telephone numbers from area codes. Now let’s break each formula down to see how it works. LEFT(text,num_chars) Returns the specified number of characters from the start of a text string. So in our example text is cell B3, and the numbers of characters we returned is 7 (remember to include any spaces as characters.) The result is The cat   RIGHT(text,num_chars) Returns the specified number of characters from the end of a text string. So in our example text is cell B3, and the numbers of characters we returned is 4 (remember to include any special characters, in this case the full stop.) The result is mat.   MID(text,start_num,num_chars) Returns the character from the middle of a text string, given a starting position and length. So in...
Read More