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

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
 
G

Gord Dibben

Copy into Excel then Data>Text to Columns>Delimited by comma.

Gord Dibben Excel MVP
 

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

Similar Threads

how do i convert names to initials in excel 2
Going from column to comma separated list... 1
importing list with commas from WORD, to individual .xls cells? 1
Converting list of numbers in Excel to a string of text in Word 2
How to create a single line separated by commas from a matrix? 2
how to convert my excel data to word label 2
Need help getting data from Word to Excel 4
How can I merge address list from excel to a word premade format? 1

Top