ladyredbull115
New Member
- Joined
- Nov 29, 2016
- Messages
- 9
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 \
For example:
[TABLE="width: 1790"]
<tbody>[TR]
[TD="width: 1790"]c:\users\user.name\appdata\roaming\baidu\baidurjdownloader\1.6.0.77\bdrcdl.exe
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.
[/TD]
[/TR]
</tbody>[/TABLE]
For example:
[TABLE="width: 1790"]
<tbody>[TR]
[TD="width: 1790"]c:\users\user.name\appdata\roaming\baidu\baidurjdownloader\1.6.0.77\bdrcdl.exe
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.
[/TD]
[/TR]
</tbody>[/TABLE]