Hi,
In row B of my worksheet, I have pasted the complete path and file names of my music files. Starting in row C, I have converted text to columns using "" as the delimiter.
The final row displays the actual name of the .mp3 file, but the filenames are not all in the same column because the path length varies.
I'm trying to pull the last value in each row, which will contain "???.mp3" into a single column, but unable to figure out how to do it.
Please let me know if you can help.
Thank you,
-Scott
Bookmarks