Vendor Extraction- Credit Card Transaction

I am creating a credit card analysis file on excel where my goal is to extract the vendor from each transaction, map it into a category and then create a pivot table that aggregates this data on a category basis for every month. I would have a separate tab where i would take the column that contains the vendor remove duplicates and categorise them.

Problem: i am having a hard time formulating the extraction of the vendor name from the transaction description as their formatting is inconsistent. Excel online requires a paid subscription to use copilot which i was thinking to use for this purpose.

Any guidance is appreciated.