Split Subject in Folder and Subfolder

[tiger19]

Hi, I would like to extract and split the subject from one of the outlook folder and subfolder. How can I do that?

The subject will comes in format as below:

xxxxx / xxxxx /xxxxx/ xxxxx

[MarvinP]

Hi tiger,

In the Power Query tool there is a function called "Split". I think this would work great for your problem.

Watch a video of it at:

https://www.bing.com/videos/search?q...816C&FORM=VIRE

[tiger19]

I think the video is different solution. I am thinking if we can use VBA from excel to split the subject extracted from outlook folder and subfolder.

[Pepe Le Mokko]

I think the video is different solution

Did you give it a try?