Help with: =RIGHT(A2,LEN(A2)-FIND(" ",A2))

Giganews Newsgroups
Subject: Help with: =RIGHT(A2,LEN(A2)-FIND(" ",A2))
Posted by:  Stunners (massuds20…
Date: Thu, 13 May 2004

Ok, Am trying to split up Full Names in a cell. I got this formula from MS's
training section of their website.
It works great when the name is John Smith. Problem is when the guy's name
is something like John A. Smith. It only recognizes the first space, and
counts the last name from there.

My names have as many as 2 or 3 spaces (John and Sarah Smith).
Can someone please help me?