MID Formula

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...

#Excel

Featured Posts
Recent Posts