Find if the number is present in string VBA

[briguyUSA]

Does anyone know a method in VBA to find if the number is present within a string? For exmaple, I am searching through a column to find "284988" but it may be stated as "284988-25-1." I want the code to confirm that 284988 is indeed within the string albeit the extra bits. thanks

 

[Joe4]

Let's say that you have "284988-25-1" in cell A1 and 284988 in cell B1.
To see if B1 is found in A1, you can do this:

=IF(ISNUMBER(SEARCH(B1,A1)),"Found","Not Found")

 

[Fluff]

You haven't given us much detail, but you can do it like

   For Each cl In Range("G2", Range("G" & Rows.Count).End(xlUp))
      If InStr(1, cl.Value, "284988") > 0 Then cl.Offset(, 1).Value = "Yes"
   Next cl

 

[Joe4]

Whoops. Sorry. I overlooked the VBA part.
But looks like Fluff's got you covered!