How do I search for a pattern of text in cell using VBA?
I've looked into the instr and find method but this still eludes me.
For example, I've got a list of clients with special IDs attached next to their names. (i.e. John Smith ABC1234).
How do I search the cells to determine...