Find and Replace?

[Sionos]

Hi all,

I have a database export that contains names and emails (i attach a test sample). Unfortunately the list of records (around 1100) are not formatted and are just in one column and would take a long time to manually edit. Is there a way I can separate the names and the email (or emails) from the other characters and transfer them into separate columns (e.g. Name, Email1, Email2, Email 3) for easy storage and usage?

I have no idea if this can be done easily but I would really appreciate some guidance.

Cheers in advance!

[martindwilson]

firsy use find/replace to get rid of all those """"""
find "
replace ,dont put anything in the replace field click all
next from tha data tab use text to columns,delimited
click other put a , in the box next to it click finish

[Sionos]

Thank you very much! That worked a treat!