Imported text separation problem

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have pasted some text from a web page into a worksheet.
It is written in the format;
Restaurant, Street, Town; Restaurant 2, Street, Town; Restaurant 3, Street,
Town
Currently it is all in one cell.
I would like to change it to be in three columns (restaurants, street,
town) and each entry (restaurant) on a separate row.
Any help is much appreciated.

Dave
 
I would suggest that in a text editor you replace the semi-colons (or
perhaps the semi-colon space sequence) by paragraph marks.
Then import the file into Excel specifying the comma as delimiter.
 
David said:
I would suggest that in a text editor you replace the semi-colons (or
perhaps the semi-colon space sequence) by paragraph marks.
Then import the file into Excel specifying the comma as delimiter.
--
David Biddulph

"Dave" (e-mail address removed) wrote in message
I have pasted some text from a web page into a worksheet.
It is written in the format;
Restaurant, Street, Town; Restaurant 2, Street, Town; Restaurant 3,
Street,
Town
Currently it is all in one cell.
I would like to change it to be in three columns (restaurants,
street,
town) and each entry (restaurant) on a separate row.
Any help is much appreciated.

Dave
-
Click to expand...

In addition to David's suggestion, in Word you can also replace the
comma by a tab (^t). The tab works as a column separator when feeding
back into Excel. Careful though with addresses that contain a comma
(eg for the house number).
 
Back
Top