Extract from a text string

[leimst]

Hello,

I have a column of first names and middle initials. What formula could I use to extract the first name only?

Thank you in advance for any assistance,

leimst

 

[Somendra Misra]

Hi leimst,

Can you post some example of data?

Regards,

 

[NARAYANK991]

Hi ,

If the first name is separated from the initial by a space , then a straightforward

=LEFT(cell , FIND(" ", cell & " ") - 1)

should work. Replace the placeholder cell by an actual cell address.

Narayan

 

[leimst]

That worked great! Thanks Narayan!

 

[SATISH KULKARNI]

Hi, Narayan sir,

How to locate if no similar pattern is separating the fields. Actually I have posted same type of problem in my earlier post. I hope you will guide. Thank you.