how can I separate 5 items from 1 column

[djmatok]

Song Composer % Controlled Our Share Status Date
Young Girls Hernandez/Lawrence/Levine/Bhasker/Haynie 16.630 498.90 Inactive - Dead 04 / 06 / 2013

[NU2vba]

djmatok,

you can try using "Text to Columns" feature under Data Ribbon, set delimiter to space. The only problem with this option is it will separate anything with a space to a seperate column. E.g. Young Girls will show up in 2 columns.

[FDibbins]

What will the division be? Maybe uploada few samples, along with your expected outcome?

If you were trying to show the split with "/", then you have 7 breaks not 5?