View Single Post
  #2   Report Post  
KL
 
Posts: n/a
Default

menu DataText to Columns..., on screen 1: choose the option 'Delimited', on
screen 2 choose delimiter: 'space', etc.

Regards,
KL


"Steven S" wrote in message
...
I have a field called Contact that has First Name and Last Name. I would
like to split this into 2 cells, one for First Name and one for Last Name.
How do I do this? Thank you for your help.

Sincerely,
Steven S