Divide existing data in cell
 

How do I take the contents of col A (first name last name) and split the col
into col A (first name) and col B (last name)?

Divide existing data in cell
 

highlight column A
click data then choose text to columns
click delimited
click next
check space
click finish

--


Gary


"Jerry Foley" wrote in message
...
How do I take the contents of col A (first name last name) and split the col
into col A (first name) and col B (last name)?