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?