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)?
|