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.