name format change - (LastName, FirstName) to just (FirstName)

Hello talented people of ExcelForum
you guys are always here to help. i appreciate you guys a lot.
i need your help once again... please...
i have an excel spreadsheet that has peoples names in the format of lastname comma first name.
i would like to know how to change the format of the name to only show first name.
i currently have this
=MID(A4,FIND(" ",A4)+1,LEN(A4)-1)
but the problem with this formula is that if they have a middle name it shows their middle name too
i would like first name only. please help.
thanks.

here is a sample worksheet
notice that some people have middle names, some do not.
Name Change.xls

Originally Posted by Fotis1991

Hi

Maybe this will work for you.

=RIGHT(A4,LEN(A4)-FIND("*",SUBSTITUTE(A4," ","*",LEN(A4)-LEN(SUBSTITUTE(A4," ","")))))

if they have a middle name, this just shows middle name or initial.
but it works for first last names only.

Originally Posted by Haseeb A

This should work.

Please Login or Register  to view this content.

this one shows first and middle.