=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))

--
Regards,
Dave


"Frosty 1234" wrote:

Have cells with First Last names in them - need last name only. How to delete
all characters up to and inlcuding the first blank space from left to right.
I am having difficulty because the length of the first name varies...
--
Thanks so much