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
(e-mail address removed),, inglese, ANDREA
(e-mail address removed),, Mulondo, Mashudu
(e-mail address removed),, Urbina, Ivonne
(e-mail address removed),, 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top