excel_2009
Active Member
- Joined
- Sep 14, 2009
- Messages
- 318
Hi excel gurus!
I'm struggling to find any resources on this but is it at all possible to do the following:
I have rows of text which contain semicolons after each phrase, I simply want to count the number of instances of these phrases for example:
Hello;Error;T-Shirt
Hello
Error;T-Shirt
Jumper;Hello how are you
The output would be:
<tbody>
</tbody>
Is this possible? if so how?
Many thanks!!!!
I'm struggling to find any resources on this but is it at all possible to do the following:
I have rows of text which contain semicolons after each phrase, I simply want to count the number of instances of these phrases for example:
Hello;Error;T-Shirt
Hello
Error;T-Shirt
Jumper;Hello how are you
The output would be:
Hello | 2 |
Error | 2 |
T-Shirt | 2 |
Jumper | 1 |
Hello how are you | 1 |
<tbody>
</tbody>
Is this possible? if so how?
Many thanks!!!!