Excel 2010 - Formula to calculate Surname from Full Name

Dear Experts,

Maybe that is an easy question could you please have a look on the attached Excel file, which formula could show the Surname of the people in the A column? So basically in each case those characters which are after the space

Printscreen
Thanks,
CalcSurname.xlsx
LVL 1
csehzIT consultantAsked:
Who is Participating?
 
Randy PooleConnect With a Mentor Commented:
Your formula would be:
=RIGHT(A2,LEN(A2)-FIND(" ",A2,1))
0
 
Shaun KlineConnect With a Mentor Lead Software EngineerCommented:
=IFERROR(MID(A2, FIND(" ", A2) + 1, LEN(A2) - FIND(" ", A2)), "")

Then copy down the column.
0
 
IrogSintaCommented:
=RIGHT(A2,LEN(A2)-FIND(" ", A2))
But be aware that this will not work for certain names such as Bobby Joe Owens or Billy Jean King since you will end up having the wrong surname.
0
 
csehzIT consultantAuthor Commented:
Thanks both versions are working of course, you both were so fast that I have just split the points between the solutions
0
All Courses

From novice to tech pro — start learning today.