Previous Topic Next Topic

Multiple text in a cell

Closed
AfsanaEssop - Jun 19, 2018 at 06:07 AM
 Blocked Profile - Jun 19, 2018 at 04:48 PM
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 response

Answer 1 / 1
Blocked Profile
Jun 19, 2018 at 04:48 PM
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!
0

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Can’t Log into Instagram from Multiple Devices
Isabella -
Abhishek0025 -

5 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response