Multiple text in a cell

Question

Multiple text in a cell

[Closed]

Report

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

Multiple text in a cell
Duplicate rows multiple times based on cell value ✓ - Forum - Excel
How to put multiple lines in excel cell - How-To - Excel
Excel vba insert multiple rows below active cell - How-To - Excel
Excel vba rename multiple sheets based on cell value - How-To - Excel
Excel multiple checkboxes in one cell - How-To - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2018-06-19T16:48:32-0400

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!

Multiple text in a cell

1 reply

Your reply

Subscribe To Our Newsletter!