Finding a text string within a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This seems like a no-brainer, but I haven't figured it out. I want to test a certain cell to see if it contains the words "JR". There are other words in that same cell

Thanks in advance

-Beverly
 
One way

=ISNUMBER(FIND("JR",A1))

--

Regards,

Peo Sjoblom


Beverly said:
This seems like a no-brainer, but I haven't figured it out. I want to
Click to expand...
test a certain cell to see if it contains the words "JR". There are other
words in that same cell.
 
=COUNTIF(A1,"*JR*") - Not case sensitive

=NOT(ISERROR(SEARCH("JR",A1))) - Not case sensitive

=NOT(ISERROR(FIND("JR",A1))) - Case sensitive

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Beverly said:
This seems like a no-brainer, but I haven't figured it out. I want to test a
Click to expand...
certain cell to see if it contains the words "JR". There are other words in
that same cell.
 
I don't see how any of the answers identified a word, they
all identified a string. The other words that might exist
might prove more interesting if they are "I", "II", "III", "IV", "V".
Such questions always come down to knowing your data,
including punctuation and placement.
i.e. Sr Juan Lopez
Harvey Brown, Sr
Not to mention that people have names that look like titles/rank,
but as far as I know they don't abbreviate them.
 
LOL - I only really looked at the subject title Dave, but I take your point :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
 
That's probably the difference, I never pay any attention to what
was in the subject once I start to answer a question. I had a manager
that nobody could read his email until we finally realized that the
first sentence is supposed to be a continuation of the subject.

Ken Wright said:
LOL - I only really looked at the subject title Dave, but I take your point :-)

David McRitchie said:
I don't see how any of the answers identified a word, they
all identified a string. The other words that might exist [clipped]
Click to expand...
Click to expand...
 
LOL - I'm also not consistent either. I was answering one question, over in
tek-Tips I think, and i went down one road whilst others went in another
direction. One of them then queried why I hadn't been specific about the answer
I gave and I gave some answer about not knowing what the OP was really after, to
which he replied - 'Isn't it what was in the title', which had I realised, gave
the whole damn question a new meaning - Doh!!!

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



David McRitchie said:
That's probably the difference, I never pay any attention to what
was in the subject once I start to answer a question. I had a manager
that nobody could read his email until we finally realized that the
first sentence is supposed to be a continuation of the subject.

Ken Wright said:
LOL - I only really looked at the subject title Dave, but I take your point :-)

David McRitchie said:
I don't see how any of the answers identified a word, they
all identified a string. The other words that might exist [clipped]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top