Text to columns

[timc03]

I have cells which contain multiple names, but they are separated by different values. I want to split these into separatae cells in the same row.

E.g.
I start with...
Row 1 cell 1 = Mr Smith, Dr Jones
Row 2 cell 1 = Dr Peter Dent/Professor Nick Dole/Jim Gomez

I would like to finish with...
Row 1 cell 1 = Mr Smith Row 1 cell 2= Dr Jones
Row 2 cell 1 = Dr Peter Dent Row 2 cell 2 = Professor Nick Dole Row 2 cell 3 = Jim Gomez

I can't do this with simple 'Text to column'. Any suggestions?

 

[RonB1111]

Here's how to do it with "Text to Columns": In the wizard,
Step 1. Check the file type as "Delimited"
Step 2. Place check marks in both the "," and "Other" delimiter. In the box next to "Other", type in a /
Finish

 

[timc03]

Here's how to do it with "Text to Columns": In the wizard,
Step 1. Check the file type as "Delimited"
Step 2. Place check marks in both the "," and "Other" delimiter. In the box next to "Other", type in a /
Finish

What about names that are run together, like

John SmithBrad Helmuth

Split to John Smith Brad Helmuth