I need here
i have a column A that is full of data like this
i need both VBA and Formula solution, i will use formula for small data and the VBA for bigger data on my automation too.
i want in column B to any data after the second backslash for example the first cell should give me Product10019000 \Product 10019000\ in column B and next cell like this PPFJJ10019000 \Product10019000\Product 10019000\Product 10019000\
D:\Global\Product10019000 \Product 10019000\
D:\Ren\PPFJJ10019000 \Product10019000\Product 10019000\Product 10019000\
C:\Product 10019000\Product 10019000\Product 10019000\