Find text within a comma delimitated string

Mistermonopoly 

Try with a Custom Function in VBA, you can write a custom function to check if "abc" appears as a standalone item in a comma-delimited string, regardless of its position within the string. Below is a VBA function that you can use:

Vba Code (find in insert file):

Function FindABC(ByVal inputString As String) As String
    Dim dataArray() As String
    Dim element As Variant
    
    ' Split the input string into an array using comma as delimiter
    dataArray = Split(inputString, ",")
    
    ' Loop through each element in the array
    For Each element In dataArray
        ' Check if "abc" is found in the element
        If InStr(1, Trim(element), "abc", vbTextCompare) > 0 Then
            ' If "abc" is found, return "Yes" and exit the function
            FindABC = "Yes"
            Exit Function
        End If
    Next element
    
    ' If "abc" is not found in any element, return "No"
    FindABC = "No"
End Function

Steps to Implement:

1. Press Alt + F11 to open the Visual Basic for Applications (VBA) editor.
2. Go to Insert > Module to insert a new module.
3. Copy and paste the above VBA function into the module.
4. Close the VBA editor.
5. Now, you can use this custom function FindABC in your Excel sheet.

In Excel, in column C, enter the formula =FindABC(A2) where A2 is the cell containing your data. Then, drag the formula down for all rows to check each cell in column A.

This VBA function will correctly identify instances where "abc" appears.