Multiple text in a cell Closed

Question

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

ac3mark · Answer

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!

Multiple text in a cell

1 response

Similar discussions

Subscribe To Our Newsletter!