Macro to split mult text in the cell to separate cells

[Ron de Bruin]

Hi Floss

Use Data>Text to Columns in the Menu Bar

 

[Gord Dibben]

floss

Data>Text to Columns.

Play with the options and parameters to see if you can come up with some
combination.

Gord Dibben Excel MVP