LIKE Function Available in Excel?

  • Thread starter Thread starter dpeacock5498
  • Start date Start date
D

dpeacock5498

Hey everyone. I am an Access User but I am wanting to know if there i
the ability to use the "LIKE" Function (or something like it) i
Excel.

For Example I have product Categories that Start with "TS -". Othe
than the LEFT Function how could I do an IF Statement using LIKE?

Thanks in advance for you responses
 
There is no like as a worksheet function , so you can't. You can either use
LEFT, MID, or FIND. In addition, in SUMIF or COUNTIF, you can use wildcards,
such as

=COUNTIF(A1:A100,"TS-*")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
=COUNTIF(A1,"*TS -*")

or

=ISNUMBER(SEARCH("TS -",A1))

or

=ISNUMBER(MATCH("*TS -*",A1,0))

HTH
Jason
Atlanta, GA
 
Back
Top