Separating out names all in one cell

[shobolos]

From an external source I have a list of names (all in one cell) separated by commas and spaces –

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.

 

[gaz_chops]

Have you tried "Text to Columns"?

 

[Mike LH]

Hi,

Put this in R2 and drag right.


=TRIM(MID(SUBSTITUTE("," & $B2&REPT(" ",6),",",REPT(" ",255)),COLUMN(A1)*255,255))

 

[shobolos]

Perfect. Thank you.

 

[gaz_chops]

You're welcome.