Formula to extract certain data

[leah72]

Hello, I have an excel spreadsheet that have multiple cells that contain the following; last name, first name, middle name. I am using the following formula to extract only the last name, first name. This works great however there are a few cells that only originally contain the last and first name and don't have a middle name so it's showing a #Value with those ones
=LEFT(A2,FIND(",",A2,FIND(",",A2)+1)-1)
Any idea how to modify this formula to include those names that dont have a middle name to get rid of? thank you in advance.

[Jacc]

How about:

Please Login or Register  to view this content.

[leah72]

Perfect, thank you so much.

[Jacc]

--------------