How to search Particular number string

Closed
Report
Posts
1
Registration date
Tuesday June 23, 2015
Status
Member
Last seen
June 23, 2015
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
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

2 replies

Posts
1326
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 28, 2021
241
Hello Arpanpatil2000,

Assuming that your numbers are in Column A starting in A1, then in B1:-

1) If you just want to return "True" use the following formula:-
=ISNUMBER(SEARCH(220,A1))


If not "True" then "False" will be returned.

2) If you want to return the value 220, then use the following formula:-

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


If true, the formula will return the value 220. If false, the cell will remain blank.

From B1, drag the formula down as far as you need.

I hope that this helps.

Cheerio,
vcoolio.
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
arpanpatil2000, Good morning.

Suppose your data is starting at A2.

Try to use:
B2 --> =IF(ISERROR(FIND(220,A2)),"NOT FOUND","OK")

Is this what you want?
I hope it helps.