I have an excel spreadsheet with a column of addresses of different lengths
like:

Eastfield Business Park
Newark Road
South Glenrothes
Fife
Scotland
KY7 4NS

I need to separate the addresses into separate columns, I've tried using
text to columns but had no luck, is there any other way?

Lisa