DigDB will parse each cell's text, carve out the text around the first '@' character, then match it against the RFC email address format. DigDB recognizes all country codes and domain extensions. Only valid email address will be extracted.
Practice file - extract-valid-email-demo.xls (16k)
Copyright © 1999-2007 All rights reserved
Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user