Post the *exact* formula you are trying.

Here's another way to do the same thing:

=MID(A1,FIND(" ",A1)+1,255)

--
Biff
Microsoft Excel MVP


"Libby" wrote in message
...
I am trying this formula and it tells me that I have too few arguments.
what
am I doing wrong.
--
Libby


"David Billigmeier" wrote:

=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