How to search numeric value from a range in excel

Question

I want to match the numeric code : 123456 from a range which includes different alphanumeric codes like IFCW123456-BLACK.

Can you please suggest some excel formula for this.

Thanks.

You can extract the numbers from the string http://stackoverflow.com/questions/7239328/vba-how-to-find-numbers-from-string — Jon Carlstedt, Nov 11 '13 at 13:24

score 0 · Answer 1 · answered Nov 11 '13 at 13:12

0

You can try to use function FIND:

=FIND(123456, <cells interval>)

answered Nov 11 '13 at 13:12

andrey_sz

1 Answers1