Partial match to search number and text

[chaiyya345]

Hi All,

I have an issue for searching for a partial number or text for only with 7(number) or 7 pieces (text). This is what I want to achieve.
However, it also searches anything with 7 & returns as TRUE which is wrong, eg 71 (number) or 71 pieces (text).

Any help is great appreciated. Please find the attachment.

Thank-You very much.

[JieJenn]

Maybe something like =OR(A1=7,ISNUMBER(SEARCH("7 ",$A1))).

[chaiyya345]

Hi Jie,

Thanks for your help & it worked!

Will close this thread to Solved & reputation issued to you.

Thank-You very much

[Bo_Ry]

Please try

=--LEFT(A1,FIND(" ",A1&" "))=7

or

=ISNUMBER(FIND(" 7 "," "&A1&" "))

[chaiyya345]

Hi Bo,

Yes it solved too. reputation added to you too.

Thank-You very much

[JieJenn]

Please try

=--LEFT(A1,FIND(" ",A1&" "))=7

I thought about using that formula too, but then I realized if I have something like "I have 7 pieces", then the formula is going to fail.

[chaiyya345]

Hi Jie,
Yes you are right!, perhaps i should be more specific for any text with 7 or just number 7 .

Thank-You very much.