top of page

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

Featured Posts
Recent Posts
Archive
Search By Tags
Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square

 

 


E: Office@iFRC.co.uk

 

T: (01889) 883860

 

 

CONTACT US:

 

iFRC Limited

1 Abbey Gardens,

Great Haywood,

Staffs. ST18 0RY

 

© 2015 iFRC Ltd 

bottom of page