Thanks for your help.

KL wrote:
Hi Kim,

Try this:

=LEFT(TRIM(A1),FIND(" ",TRIM(A1))-1)

and

=MID(TRIM(A1),FIND(" ",TRIM(A1))+1,LEN(TRIM(A1)))

Regards,
KL

I have a long list of names in Excel where the first and last name are in
one
[quoted text clipped - 5 lines]
different
length. Is there an easier way to do this?

--
Kim


Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1