How do I convert comma separation to Table format

G

Gunjani

I have a list email adds separated by commas followed by forenames &
surnames, how may I convert this list in tabulated form... A table for
the following column for the email add, a column for the forename and a
column for the surname...

e.g

ferreira @benco.co.uk,, Ferreira, Marnie
[email protected],, inglese, ANDREA
[email protected],, Mulondo, Mashudu
[email protected],, Urbina, Ivonne
[email protected],, Williams, Brennan


--
Many Thanks

Gunjani
"Every man is afraid of something. That is how
you know he loves you; when he is afraid of
losing you."
 
G

garfield-n-odie

Select the list, click on Table | Convert | Text to Table | Separate
text at: Commas | OK.
 
Top