Separating data to put in seperate cells

[Wombat]

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

 

[Jacob Skaria]

--Select the range/column needs to be changed.
--From menu Data>Text to Columns will populate the 'Convert Text to Columns
Wizard'.
--By default the selection is 'Delimited'.
--Keep the selection and hit 'Next'.
--From the Step2 of the Wizard from the options select Semicolon
--Next Hit Finish

If this post helps click Yes

 

[JBeaucaire]

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?

 

[Wombat]

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

 

[David Biddulph]

Data/ Text to columns
Semi-colon as delimiter

 

[Gord Dibben]

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