VBA "Scripting.Dictionary" Word Occurences under each category

I am very new to dictionaries in VBA but I found a macro that does almost exactly what I need it to in a fraction of the time as a formula. I have a list of items that belong to different categories. In one column I have the category, in columns next to it I have the product title, description, and a few bullet points with more descriptions. My goal is to have a macro go through all the items in my sheet and return a list of words in those columns and their occurences in each category.

I've attached a sample with some dummy data. Dummy_Data.xlsx

Below is the code that I found at this page.

Sub HTH() 
    Dim vArray As Variant 
    Dim lLoop As Long 
    Dim rCell As Range 
     
    With CreateObject("Scripting.Dictionary") 
        For Each rCell In Range("A1", Cells(Rows.Count, "A").End(xlUp)) 
            vArray = Split(rCell.Value, " ") 
            For lLoop = LBound(vArray) To UBound(vArray) 
                If Not .exists(vArray(lLoop)) Then 
                    .Add vArray(lLoop), 1 
                Else 
                    .Item(vArray(lLoop)) = .Item(vArray(lLoop)) + 1 
                End If 
            Next lLoop 
        Next rCell 
        Range("B1").Resize(.Count).Value = Application.Transpose(.keys) 
        Range("C1").Resize(.Count).Value = Application.Transpose(.items) 
    End With 
End Sub

This code gives me the count of each word's occurence. The shortcoming here is that it includes special characters. For example: Ther could be the word "great" and "great," and each one would have their own count. My goal is to eliminate the special characters before counting. Also, I would like it to give me the word and the count within each category.

This next request is only optional but would be great. I would also like to get a list of two word combinations and their counts. For example if a phrase contained "big dog" then it would be counted. If a phrase contained "Big bad dog" then "Big Bad" and "Bad Dog" would be counted.

Also, I would like it so it isn't case sensitive when counting.

Any help on this would be greatly appreciated.