Count words in a string and Summary

RodrigoAC 

I suggest you to use PQ to get the result

1. split ocrruences by comma to rows

2. group by

pls see the attachment below

Hi RodrigoAC 

1. Click on Transform Data in the ribbon to get to Power Query.

2. Then, in the Home tab, go to Split Column and click on By Delimeter.

3. Then, use the following criteria from below screenshot:

4. Close and Apply.

5. Now just drag the Column with the words into the table.

6. Do the same as step 5 and then select "Count" on the second Column you brought in to give you the count of each.

Hope that helps 🙂

Theo