Karen, Have a look at using <data <text to columns You van use the space
as a separator.
--
Greetings from New Zealand



"Karen D" wrote in message
...
I'm trying to separate the last name from the first name in a field. I
can
get the first name by using the "left" function. Does anyone know how to
get
the last name? I tried using "right" function but on some it gives me the
whole last name plus part of the first name, others it gives me some of
the
letters of the last name. Please advise - thanks!