I want to search particular number string from all the number data

[arpanpatil2000]

Hi,

I want to search particular number string from all the number data.

E.g. -

9822013351
9822012146
9822030078
9822046440
9850038947
9822841819
9850049182
9850049364
9850959337
9850933737
9881499208
9850899103
9881144884
9881157621

from these number i want to search numbers which are having 220 anywhere in it

Kindly please help.

Thank you

[Pepe Le Mokko]

And when you have found them, what happens?

You could for example filter on numbers containing 220

[Glenn Kennedy]

You could try:

=IF(ISNUMBER(SEARCH(220,A1)),A1,"")

which will return the value in A1 if it contains 220, or blank if it does not contain 220.

[arpanpatil2000]

Yes I want to filter those numbers and copy them to new sheet

[arpanpatil2000]

Thank you Glenn that worked, but was willing to do it on sheet level so that i can sort the data i need.

[Glenn Kennedy]

This array formula will do that... They're a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...