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

This formula should do the job
=TRIM(RIGHT(SUBSTITUTE(A1;"-";REPT(" ";LEN(A1)));LEN(A1)))

(replace semi-colons with commas)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This didn't work. It just replaced the whole row with the header from it's column.

It works for me.

Do note that, as with most Excel formulas posted in forums where no cell address context is given, the formula assumes the data are in A1 and the formula is in any other cell. Obviously, you can't put a formula in the very cell you want to extract data from and, if the cell you want to process isn't A1, you need to change the formula's cell references.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Cross post http://www.excelforum.com/excel-form...-to-point.html

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post