=RIGHT(L1,FIND(" ",L1))
--
Gary''s Student
gsnu200709


"Cathy" wrote:

In Column L, I have a persons first name and last name eg: John Smith. In
column N, I just want the persons last name to appear. I know this must be
an easy formula, but I just cannot figure it out.

I appreciate your help.