A1: holds excel.com

In B1: ="*@"&A1



"Robert Brown" wrote:

I haven't found the magic way to search for the @ symbol in a character
string. Is there a special way to key this so FIND will work?

If that's not possible, any suggestions on converting just domain names to
wild carded email address formats? IE: take excel.com and convert to
.

Thanks