Searching for Text in a Cell

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have a column of cells that contain business names. I
need to set up a formula that will deal with customers'
names and business names differently. For example,
individual customers are listed as:

Smith, Mike A.
Jones, Sam R.

While businesses are listed as:

Acme, Inc.
Herbert Family Trust
Wagner Trustee

I don't need to change anything with the business cells,
so I need to identify those cells with Inc, Trust, etc.
Is there a formula I can use that will find text within a
text sting (ie Inc, Trust, Corp)? Since this text can
appear at any character position, this seems like a
difficult task.

Thanks for the help!
 
Alex

You can use FIND(). This will return the position of the text in the cell
and will return #N/A if it's not there. Check Help for more info.

Andy.
 
countif would be a good formula to use, for the string you are searching
for, you can enter *corp* and it will find "Corporation" or "Corp." or
"Corp"

countif(a1,"*corp*")

if you want to count all the 'trust' related titles, you can use
countif(a1:a100,"*trust*") for example.
 
Back
Top