Keyword Column to Category Automation in Excel?

Hi I have a question if the following is possible in Excel.

I use a program that will export to an excel file. I want to use keywords in order to categorize my da

hi akrobatik, Excel can separate the commas using Text to Column
Select the column & go to Data -> Text to Column -> Delimited -> Next -> Check the Comma option -> Finish

Do upload an eg for us so we can see what other problems we face