Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported text separation problem
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported text separation problem
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" 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported text separation problem
David Biddulph;2576383 Wrote: 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" 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 - 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). -- Henk57 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem in editing imported file | New Users to Excel | |||
Formatting Imported Text | Excel Discussion (Misc queries) | |||
Imported Data Date Format Problem | Excel Discussion (Misc queries) | |||
text and number separation | Excel Discussion (Misc queries) | |||
problem working with time data imported from text file | Excel Worksheet Functions |