Change 2 names in one cell to one name in 2 cells

  • Thread starter Thread starter wab
  • Start date Start date
W

wab

Is there a way that if there are two names in one cell (a1), i.e.;
Johnson--Jackson, that they can be changed to be listed in two
different cells, such as, Johnson in cell b1 and Jackson in cell b2. I
have a very long list of names and I do not want to go through the list
and type every thing in again.
Thanks for any assistance you can give me. WAB
 
Back
Top