A couple of queries

If your name (i.e. Mary Jo Smith) is in B1, then then formula needs editing to that cell reference

=RIGHT(B1,LEN(B1)-FIND("^^",SUBSTITUTE(B1," ","^^",LEN(B1)-LEN(SUBSTITUTE(B1," ","")))))

Can you provide a small zipped sample of your data, this will be easier to understand what you are trying to do, then hopefully a solution can be found.

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Sent to > Compressed file”, then attach this to your post.