View Single Post
 
Old 05-30-2013, 03:21 PM
Chayes Chayes is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: May 2012
Posts: 79
Chayes is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You should be able to use a wildcard Find/Replace, where:
Find = <[0-9A-Za-z.]{1,}\@[!. ]{1,}.*>
Replace = nothing
No code required. Of course, if you're doing this regularly, simply record the above as a macro.
Hi Paul

Ok thanks for that. it works like a dream and clears all the email addresses out. Brilliant.

Just A FYI - It did miss one email address which has an underscore in it , but I was able to remove it manually. It only removed the text after the underscore.



Best Wishes


Colin
Reply With Quote