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 DataText 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
---------------
Jacob Skaria


"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 :-)

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 :-)

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 :-)

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 :-)

Data/ Text to columns
Semi-colon as delimiter
--
David Biddulph

"Wombat" wrote in message
...
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 :-)