Need to check if specific number is part of a string

I have a string in cell A1, such as "asdfk1234jh", and cell B1 contains the number "1234". I want to determine if the exact number in B1 is present within the string in A1. Existing solutions only return "TRUE" if any part of the number is found, like "12" or "123", but I require a formula to confirm if "1234" specifically exists in A1.

Welcome to the forum.

Try this:

=ISNUMBER(SEARCH("1234",A1))

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

One way (there'll be a better solution, though):

=MID(A1,MIN(IFERROR(SEARCH(CHAR(ROW(INDIRECT("48:57"))),A1),"x")),MAX(IFERROR(SEARCH(CHAR(ROW(INDIRECT("48:57"))),A1),"x"))-MIN(IFERROR(SEARCH(CHAR(ROW(INDIRECT("48:57"))),A1),"x"))+1)

Enter with CTRL+SHIFT+ENTER.

No reply ...

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

I see you have added a workbook to your opening post without telling us!

Try this:

=IFERROR(IF(--MID(A2,MIN(IFERROR(SEARCH(CHAR(ROW(INDIRECT("48:57"))),A2),"x")),MAX(IFERROR(SEARCH(CHAR(ROW(INDIRECT("48:57"))),A2),"x"))-MIN(IFERROR(SEARCH(CHAR(ROW(INDIRECT("48:57"))),A2),"x"))+1)=B2,"Yes","No"),"No")

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Then copy down.

I understand you correctly, I will try to search that number in text string (A2), then to chech whether one letter left and one letter right are alphabet or not. If both are, then "yes"
...x1234y....with x to the left and y to the right then yes

Please Login or Register  to view this content.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Originally Posted by Spammerworld

Thank you.. This works well.

Which work? or both?

What does? My solution or Bebo's?

Here's mine in action:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D
1	String	Number	Result	AliGW
2	SDFSDF1234FF	1234	Yes	Yes
3	x2dfdfs1234dfF	12	No	No
4	dsfsd325fgfdgh	325	Yes	Yes
5	dsfsd325fgfdgh	32	No	No
6	SDFSDF1234FF	34	No	No

Sheet: Sheet1

Please see post #15 - the attachment shows BOTH formulae working well.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Special case:
A1=xxx12345yyy1234zzz
B1=1234
both (Ali and me) give "No"
what do you expect for this case?

I'd spotted this possible issue, too - not sure what the solution would need to be for this scenario.