This post follows on from our post dated 2 June 2017 and deals with extracting data from the middle of a string of information.
Previously we used a forename and surname and extracted the left part of the name.
Now I've added a middle name so that the string of data is:
Surname Forename Middle Name.
If I want to extract the middle part of the name, Stephen in this case, we can use a MID formula.
Using the formula:
=MID(A2,FIND(" ",A2)+1,FIND(" ",A2))
it will extract all the information between the first space and the second space, Stephen in this case.
A simple formula that helps you extract data from a list where there are separators, whether they are spaces, colons, commas, etc...