Splitting a CSV cell

[Mel Smith]

Hello Folks,

I have a spreadsheet of addresses that was created as a CSV file. In Column E the addresses have been formulated as follows: House number and road, Area, Town, County, Post code

E.g. 121 High Street, Downtown, Witney, Oxfordshire, OX7 9HD

How can I 'split' this column so that at each comma a new column is used. If the comma can also be removed great but if not it should stay with the preceding day i.e. 121 High Street,.

How may I achieve this, please? As always, your help will be invaluable.

Mel

 

[VoG]

Have you tried Data > Text to Columns, Delimited with comma as the delimiter.

 

[Mel Smith]

Hello Peter,

Perfect! Thank you.

Mel