Separating data to put in seperate cells

  • Thread starter Thread starter Wombat
  • Start date Start date
W

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 :-)
 
--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
 
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?
 
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
 
Back
Top