You are just lucky that you have a semi-colon separator.

Some of these constructs are much more difficult to break out when there is
no definite de-limiter.

In that case you would need some godawful formula.


Gord Dibben MS Excel MVP


On Mon, 26 Oct 2009 05:46:01 -0700, Wombat
wrote:

So easy! I'd expected some godawful formula. THANKS!

"JBeaucaire" wrote:

If the data is all in one column (column A?) and the columns to the right are
empty:

1) highlight the data colum
2) click DATA TEXT TO COLUMNS DELIMITED NEXT
3) click OTHER and put a semicolon in the box
4) click FINISH

All your data should have been split into multiple columns by the semicolons.

Does that help?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Wombat" wrote:

Hi!

I have a load of data in the following form:

Town;Extra;ZIP code;Phone number;Country

For the moment, I have one row of cells with all this information in... all
separated by semi-colons.
Is it possible to split the original data into 5 cells, bearing in mind that
each entry varies in length?

Thanks for any help :-)