View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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)?