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
|