View Single Post
  #4   Report Post  
drlogarithm
 
Posts: n/a
Default

Separate the names using Data/Text to Columns. Select Delimited. The
delimiters are a space and a comma (unless there are no spaces between
the the comma and the first name). Be sure to select your
'Destination' or else the separated names will replace your highlighted
names.