Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Multiple text in a cell [Closed]

Report
-
 Blocked Profile -
Hi

Please can someone help

I have text in columns that uses multiple words example, annual leave, sick leave, maternity leave and i want to add the number of times leave appears in a worksheet irrespective of what type of leave it is. I don't want to type each leave type in the formula. I am hoping there would be a way to ignore the first word and just use the leave word.

please can you help with a formula.

Greatly appreciate

1 reply

Answer 1 / 1

Typically an "*" can be used as a wildcard. Sometimes "%". Excel uses the "*". SO, with that being said, the formula would be something like: 
=COUNTIF(C2:C4,"*leave*")


Have FUN!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!