Combining Salutations with Names

[MetaGod]

Hi there everyone,

I'm attempting to streamline a project that uses multiple cells. The idea is to take a column that has a person's full name (ex. Mr. John Smith) and extract just the last name into another cell that already has the salutation of Mr or Mrs.

Column A - Mr or Mrs
Column B - empty
Column C - Mr John Smith

[oniwlmh]

Assuming the Mr/Mrs is in Column A and the full name is in Column C, the below formula should combine Column A with the last name from Column C.

=A1&" "&MID(MID(C1,FIND(" ",C1)+1,256),FIND(" ",MID(C1,FIND(" ",C1)+1,256))+1,256)