A way to filter gibberish Emails and Usernames

djclements 

You are correct, and I appreciate your clarification. I apologize for any confusion caused by my previous responses . The SEARCH function in Excel does not support full regular expressions; it primarily performs simple substring searches.

To achieve more complex pattern matching, especially using regular expressions, a more suitable approach would be to utilize VBA within Excel or a third-party tool that supports regex.

Here's an example of a VBA code snippet that you can use in Excel:

Vba code is untested, please backup your file first.

Function IsPotentialGibberish(email As String, username As String) As String
    Dim regex As Object
    Set regex = CreateObject("VBScript.RegExp")

    ' Email pattern: at least 2 letters, followed by at least 1 number, then @, some letters, dot, more letters
    regex.Pattern = "^[A-Za-z]{2,}[0-9]{1,}@[a-zA-Z]+\.[a-zA-Z]+$"
    If regex.Test(email) And Not (regex.Test(username) And regex.Test(username)) Then
        IsPotentialGibberish = "Potential Gibberish"
    Else
        IsPotentialGibberish = "Normal"
    End If
End Function

You can use this function in your Excel worksheet. Assuming your email is in cell A2 and the username is in cell B2, you would enter the following formula in another cell:

=IsPotentialGibberish(A2, B2)

This function uses the VBScript.RegExp object to perform regular expression-based pattern matching. It checks both the email and username against the specified pattern and returns "Potential Gibberish" if the conditions are met.

Remember to enable macros and use the VBA editor to insert this code into a module in your Excel workbook.

Again, I appreciate your understanding, and I hope this solution better fits your needs.

djclements 

Appreciated. We obviously made the same searches and I also checked the Insider Blog. I just want(ed) to double-check I did not miss/misunderstand something as NikolinoDE - nowhere in his 1st proposal to the OP - mentioned any specific requirement and obviously the latter had no issue implementing the various proposals (???)

Hopefully NikolinoDE will clarify things...