- Nov 29, 2016
I have many rows that contain a file path which are all different and I need to end up with only the text after the last \
The cells after the file path contain counts of times this location was accessed.
Essentially, I am looking to remove all of the text before bdrcdl.exe so that I can create a pivot table and sum up all of the counts of bdrcdl.exe
I tried =RIGHT(A29,LEN(A29)-FIND("",A29)) but that only removes the text before the first ""
Converting the text to columns works, but since each file path is a different length, it spreads the text so that I can't easily gather what I need.
Thinking I need to a macro to loop through the nested function I tried, but I am still new to VBA and not really sure where to start on that one.
Any suggestions will be greatly appreciated.