Turning data in one cell into a list

[Dracven]

Hi there, I've been sent a sheet with a list of names but pasted into one cell. Without manually going through it and pulling them out manually (they're all seperated by semi-colons) is there a way of turning them into a list in a column rather than in cell A1?

thanks

Thom

[Russell Dawson]

Hi Thom

Please post a workbook. It sounds like you need the text to columns function.

[Dracven]

Hi there,

Hopefully there should be a workbook now attached.

Thanks for your assistance.

Thom

[tom1977]

Hi use text to columns with this separator ";" next copy and paste special with transposition