• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to find the exact text string

AV114

Member
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
 
Use Find or Search
They will both return the starting position of the text string in the Cell Text
 
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
 
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?
 
Back
Top