Extract Middle Name

**roshan03** · 05-24-2019, 06:36 AM

Which is the short formula to extract middle name.

example : David samuel John

(Samuel)

**Phuocam** · 05-24-2019, 06:51 AM

Try this

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",100)),100,100))

**Pepe Le Mokko** · 05-24-2019, 07:04 AM

Some more examples please?

**roshan03** · 05-24-2019, 07:10 AM

Originally Posted by Pepe Le Mokko

Some more examples please?

How can extract

David From Below sentence

EX1 - John David MARTIN KING

EX2 - KING JOHN DAVID MARRIN

**torachan** · 05-24-2019, 07:13 AM

With three names in cell A1, with one space between names, ensure no leading space.
put formula in cell B1 and copy down column B

Please Login or Register  to view this content.

**chriskay** · 05-24-2019, 07:22 AM

Originally Posted by roshan03

How can extract

David From Below sentence

EX1 - John David MARTIN KING

EX2 - KING JOHN DAVID MARRIN

Try this:

Formula:

Please Login or Register  to view this content.

If "King" is a name prefix, you need to define whatever prefixes you want to exclude in the search formula

Re: Extract Middle Name