Matching similar entries

[Fcroft]

I have the formula

=ISNUMBER(MATCH(X1,A:A,0)) where X1 is cell you are checking for a match to

to check and see if there are duplicates in 2 rows.

Is there anyway to check to see if a cell contains a string of numbers. Example:

Cell A1 has 0000402502LK and Cell A2 has 402502. Is there anyway to get this to show up as true since the 402502 in contained in the string in A1?

[NBVC]

Something like:

=ISNUMBER(MATCH("*"&X1&"*",A:A,0))

[Fcroft]

Worked like a charm. Thanks NBVC for another quick solution to a problem!