Splitting a document with first name , last name, emails into a table

**shinbet** · 05-04-2014, 02:21 AM

Hi
I hope someone can help me

I have a word document with a couple of hundred names,
1 column with a list

Line one has first name and last night
Line 2 has an email address

there are no commas , just

Joe Bloggs
[email protected]

How can I paste this into excel and format it into separate columns (first+last name And Email address)

Thanks so much

**FDibbins** · 05-04-2014, 02:23 AM

You posted this in the excel forum. Do you want an excel answer?

**macropod** · 05-04-2014, 04:28 AM

In Word:
• press Ctrl-A, Ctrl-Shift-F9 to convert the email addresses to plain text;
• insert an empty paragraph at the start of the document
• use the following wildcard Find/Replace:
Find = (^13[!@^13]@)^13([!@^13]@\@)
Replace = \1^t\2
You will then have a tab-delimited list of names followed by emails, ready for copying & pasting into Excel.

**shinbet** · 05-04-2014, 09:47 AM

Thank you
I'd never have figured you could do it in word

Problem is, i got 0 results, i got a message

"all done. we made 0 replacements" (microsoft word 2013)

Originally Posted by macropod

In Word:
• press Ctrl-A, Ctrl-Shift-F9 to convert the email addresses to plain text;
• insert an empty paragraph at the start of the document
• use the following wildcard Find/Replace:
Find = (^13[!@^13]@)^13([!@^13]@\@)
Replace = \1^t\2
You will then have a tab-delimited list of names followed by emails, ready for copying & pasting into Excel.