How from Word a list separated by commas convert to Excel?

  • Thread starter Thread starter Gunjani
  • Start date Start date
G

Gunjani

In Word 2002, I have a list of email adds separated by commas followed
by forenames & surnames, how may I convert this list in tabulated form
to Excel... A 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
 
Copy into Excel then Data>Text to Columns>Delimited by comma.

Gord Dibben Excel MVP
 
Back
Top