Pretty simple. As an example:
.\Archive\(20140114) G2-253_G2-252 (Upstream)\(20140114) G2-253_G2-252 (Upstream).mpg
Needs to JUST become: (20140114) G2-253_G2-252 (Upstream).mpg in a different column
Problem : The amount of characters in a string can vary, and is not static.
What I want: I can put thousands of the first example in column A. I want column B to just show everything after the third ‘’. Is there a code that will put everything after the third ‘’ into column B?