Find and replace

[Don]

I have a list of names and email addresses, for example:

Bill Smith <[email protected]>

I want to delete the email addresses, leaving just the list of names.
Tried using <*> in Find (leaving Replace blank), but that deletes
everything. Must be missing something?

Checked out
http://office.microsoft.com/en-us/assistance/HP051894331033.aspx

still not sure of the solution...

 

[Suzanne S. Barnhill]

1. Press Alt+F9 to reveal field codes. Each email address will look like
this: { HYPERLINK "mailto:[email protected]" }.

2. Ctrl+H to open the Replace dialog.

3. In the "Find what" box, type: ^19 HYPERLINK "mailto:

4. Leave the "Replace with" box empty.

5. Replace All.

Don't forget to press Alt+F9 to toggle field code display back or you'll get
unexpected results the next time you open a document containing fields.

 

[50 Years of Programming Experience]

Hi Don,
I copied all the names and email addresses into Excel. Excell puts the
names in the first column and the addresses into the second column. Then you
can copy out the first column, and paste it back into your word document,

 

[Don]

1. Press Alt+F9 to reveal field codes. Each email address will look like
this: { HYPERLINK "mailto:[email protected]" }.

Thanks Suzanne, but nothing happens when I press ALT-F9. ?

 

[Don]

50 Years of Programming Experience

I copied all the names and email addresses into Excel. Excell puts the
names in the first column and the addresses into the second column. Then you
can copy out the first column, and paste it back into your word document,

hmm, doesn't seem to work for me - everything ends up in column A.

 

[Terry Farrell]

It would seem that you emails are just plain text and not hyperlinks like
those in this message. When you double-click on the addresses, does it open
up a blank addressed email? Almost certainly not for the reasons stated.

Maybe something as crude as a vertical selection and then cutting and
pasting the names into a new document. To make sure that the name are well
separated from the email addresses, use Find and Replace to search for
space> and replace with tab>. Then select all the rows and insert a tab on
the ruler so that all the addresses move well clear of the names. Now you
can do a vertical selection of the names column (using the Alt key) and cut
and paste (or copy and paste) into a new document. It's crude but it will
work.

 

[Don]

It would seem that you emails are just plain text and not hyperlinks like
those in this message. When you double-click on the addresses, does it open
up a blank addressed email?

Nope, it's just plain text. Sorry for the misunderstanding, I didn't
realize at first that it showed up here as a hyperlink.

Maybe something as crude as a vertical selection and then cutting and
pasting the names into a new document. To make sure that the name are well
separated from the email addresses, use Find and Replace to search for
space> and replace with tab>. Then select all the rows and insert a tab on
the ruler so that all the addresses move well clear of the names. Now you
can do a vertical selection of the names column (using the Alt key) and cut
and paste (or copy and paste) into a new document. It's crude but it will
work.

Thanks, that works. I never knew about vertical selection, it's
pretty handy!