Ok I'm trying this forum because when I just google for answers the language used for Excel baffles me so I apparently need more help.



I populated a large spreadsheet with music information, but unfortunately the "Artist" column all starts with a long thread like this:

E:\Various Artist 1979-2010\Karaoke English\CAPITAL KARAOKE AUSTRALIA\CKA20\CKA20\CKA20-02 - Do It With Madonna - Andriods.mp3

I only want the artist or Andriods.mp3 in this case. Is there any way to mass delete from "E: all the way to the second -"?

Thank you for any help you can provide.

Steve