I assume that your address information are stored in one column and want to
change it to one row.
Try Transpose function
If my assumption is not right, then please be more specific
===== * ===== * ===== * =====
Daniel CHEN
Spreadsheet/VBA Specialist
www.Geocities.com/UDQServices
Your "Impossible" Task Could Be Someone Else's "Piece of Cake"
===== * ===== * ===== * =====
"Lisap" wrote in message
...
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