On Nov 13, 10:42 am, JW wrote:
You trying to do this with VBA? If so, the code below will filter the
used range where column B starts with ABC.
ActiveSheet.UsedRange.AutoFilter _
Field:=2, Criteria1:="ABC*"

Melissa wrote:
Hi-

I am trying to search for the first 3 characters of a list of part
numbers. The part numbers I am trying to filter out start with the
same 3 letters, but the next 4 numbers in the part number could be
anything (ex. "ABC1234", "ABC2345").

How can I search the cells for anything containing those first three
letters?

-Melissa

I just used this code:

If Cells(r, 2).Value Like "ABC*" Then

It worked. Thanks for your help!