Hello everyone,

I got this code, improved/edited by a lovely member of this community to suit my needs, but I'm looking forward to complement it with some extra conditions regarding the presence of these specific characters (blank spaces too): ( ) < > , ; : " [ ] / ç % $

The script loops through a column containing multiple e-mail addresses, and uses a help column containing mistakes previously found. This helper column holds only the domain/provider text, which is, all characters to the right of the "@" sign. For instance: @gmlai.com; @gmial.com; @gmal.com; etc

I'm aware now that there are a known solution for this using regex (I'm not really an expert, but I kinda understood how it works). Anyway, every function using regex that I found actually gives me a boolean true/false event. As my purpose is to color the cells of every match found, I think I'd take me too much time to adapt, etc

The script I have so far is great, it does the job really fast over 100k+ rows, having +- 800 strings that I'm looking for. If I could add this to the same code, maybe using a INSTR function and pointing out all of those characters + blank spaces, that'd be perfect to me.

Anyone could give me a light on this?


Please Login or Register  to view this content.