View Single Post
 
Old 01-29-2015, 06:48 PM
Gef Gef is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Jan 2015
Posts: 11
Gef is on a distinguished road
Default I'm looking for a formula to extract all the text before the last name in a cell

Hello,

I'm trying to separate out the first and last names in a spreadsheet. I used a formula to extract the last name. Now I just want to extract all the text that is to the left of the space before the last name. Is this possible?

The text to the left of the space before the last name is totally inconsistent - - and that's ok for my purposes now.

Thanks for your help!
Reply With Quote