I'm looking for a formula to extract all the text before the last name in a cell

[Gef]

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!