Select and copy text after specified word macro

Hy!

I have a huge ammount of exported data, and one cell contains the category name and the category path too. I want to write a macro, which can find the category name, copy and paste it to an other cell, and the same for the path too.

Example:

Cell looks like this:
Category Name: ProductNameSomething, Category Path: Materials/Alloys/Something

And I need the macro to copy the ProductNameSomething and Materials/Alloys/Something to other cells (wothout the "Category Name:" and the "Category Path:").

I would really appriciate some help, how can I select and copy text in a cell after a specified word? Or is there any easier solution?

Right, I made a sample.

The character decoding is superweird, thats a website issue to solve for an other co-worker.

sample.xlsx

skip it (make a blank cell), so I can easily know, there was something wrong.

perfect, thanks!