How to search Particular number string
Closed
arpanpatil2000
Posts
1
Registration date
Tuesday June 23, 2015
Status
Member
Last seen
June 23, 2015
-
Jun 23, 2015 at 03:06 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 23, 2015 at 07:20 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 23, 2015 at 07:20 AM
Related:
- How to search Particular number string
- How to search for words on websites - Guide
- How to search nearby friends on facebook - Guide
- How to remove search baron - Guide
- How to search for a word in a pdf - Guide
- Vi search - Guide
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Jun 23, 2015 at 07:17 AM
Jun 23, 2015 at 07:17 AM
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:-
If not "True" then "False" will be returned.
2) If you want to return the value 220, then use the following formula:-
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.
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.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 23, 2015 at 07:20 AM
Jun 23, 2015 at 07:20 AM
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.
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.
