View Single Post
 
Old 05-30-2013, 04:15 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
OK, to handle those, it's just a matter of adding the underscore to the Find expression:
Find = <[0-9A-Za-z._]{1,}\@[!. ]{1,}.*>

Hi

Ok Thanks for this.

I ran it and it does deal with those with underscores perfectly.

I've attached a file with 20 sample email addresses of varying configuration so you can see the effect of the formula. Results are pretty good.



Best Wishes
Attached Files
File Type: doc Email-remove practice.doc (20.0 KB, 19 views)
Reply With Quote