Stunners

Thanks, but I already used Andy's answer.

"Peo Sjoblom" <terre08@mvp.org> wrote in message
news:OU$sklOOEHA.3708@TK2MSFTNGP10.phx.gbl...
> One way
>
> =RIGHT(A1,LEN(A1)-SEARCH(CHAR(190),SUBSTITUTE(A1,"
> ",CHAR(190),LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
>
> that will extract the last name unless there is a JR or II or something,
> those you need to
> do manually
>
> Assume you extract the last names in column G, now in another column use
>
> =SUBSTITUTE(A1,G1,"")
>
> and copy down
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Stunners" <massuds2000@yahoo.com> wrote in message
> news:9NJoc.6484$ol3.3719@fe20.usenetserver.com...
> > 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?
> >
> > Thanks!
> > Yoni
> >
> >
> >
> >
>
>