Hello,

I'm organizing my MP3 ID3 tags, using Tag&Rename (cool program). Anyway it allows for the importing / exporting of the ID3 tags, into a spreadsheet.

In a particular column the complete file path is displayed (see example below). I'm trying to get excel to ignore "C:\Users\Ian\Music\Karaoke\L\", so I can extract 'Livin' La Vida Loca - Ricky Martin.mp3'

C:\Users\Ian\Music\Karaoke\L\Livin' La Vida Loca - Ricky Martin.mp3