From an external source I have a list of names (all in one cell) separated by commas and spaces –
<tbody>
</tbody>
I would like, via a formula, to separate out these names into separate cells –
<tbody>
</tbody>
The amount of names can vary.
Any help would be gratefully appreciated.
B2 |
Sandberg, Joy, Loudon, Thomas |
<tbody>
</tbody>
I would like, via a formula, to separate out these names into separate cells –
R2 | S2 | T2 | U2 |
Sandberg | Joy | Loudon | Thomas |
<tbody>
</tbody>
The amount of names can vary.
Any help would be gratefully appreciated.