Yes you can.
Use =LEFT(A1,SEARCH(" ",A1,1)-1) in B1
and =RIGHT(A1,LEN(A1)-LEN(B1)-1) in C1

--
HTH

Kassie

Replace xxx with hotmail


"enrico via OfficeKB.com" wrote:

if lastname and firstname is in one column, can you separate it into two
columns?

--
Message posted via http://www.officekb.com