MichaelLindsay
New Member
- Joined
- Aug 7, 2014
- Messages
- 6
Hi Guys,
Have a cell full of HTML and what I want to do is to summarize all the words in the cell with their count:
What I have:
<tbody>
</tbody>
What I would like:
<tbody>
</tbody>
Formula, VBA or GUI workaround, any works for me.
Thanks in advance,
Mike
Have a cell full of HTML and what I want to do is to summarize all the words in the cell with their count:
What I have:
| Some HTML |
| <html>SomeWord1 SomeWord2 SomeWord3 SomeWord2 SomeWord4 SomeWord1</html> |
<tbody>
</tbody>
What I would like:
| Word | Count |
| SomeWord1 | 2 |
| SomeWord2 | 2 |
| SomeWord3 | 1 |
| SomeWord4 | 1 |
<tbody>
</tbody>
Formula, VBA or GUI workaround, any works for me.
Thanks in advance,
Mike
