How to find the exact text string

[AV114]

I like to use VBA or Formula to find exact text string on a cell value

Cell Text : JOHN SMITH, JUNIOR, DB JONES , JONES

need to find :

1) JOHN SMITH
2) JOHN

Could you please help me on this

 

[Hui]

Use Find or Search
They will both return the starting position of the text string in the Cell Text

 

[AV114]

Use Find or Search
They will both return the starting position of the text string in the Cell Text

But i got result for both, for me its i need like this :


1) JOHN SMITH - Result (TRUE)
2) JOHN - Result (False)

Can you help me

 

[vletm]

AV114
Is there ALWAYS something between Your meant text-term?
You asked 'to find exact text string on a cell value' ...
and without more specific rules, those both are TRUE.
How about 'name' as SMITH? Should it be TRUE or FALSE?

 

[bosco_yip]

Try,

In D2, copied down :

=ISNUMBER(FIND(C2&",",SUBSTITUTE(A$2," ,",",")&","))

Regards
Bosco

 

[AV114]

View attachment 57611

Try,

In D2, copied down :

=ISNUMBER(FIND(C2&",",SUBSTITUTE(A$2," ,",",")&","))

Regards
Bosco

Thanks

 

[vletm]

AV114
Did You test SMITH?
If not then You should notice that You would get many extra TRUEs.