Excel question

  rawsongreen 14:57 06 Feb 2010

I have a list of song titles in a column and the first 2 digits are track nos.
Is there a way of removing them, they range from 01-27.

  VoG II 15:04 06 Feb 2010

Assuming that they are in column A, in a spare column enter the formula


and drag down as far as needed. Then copy the formula results, select your original list and Edit > Paste Special, tick Values and click OK. You can then delete the column with the formulas.

  rawsongreen 15:17 06 Feb 2010

Vog once again you are brilliant.
Many thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy S9 review

ManvsMachine and other artists put Apple's iMac Pro to the test using powerful rendering tools

What to expect at Apple's 27 March education event

Comment filmer l’écran d’un iPhone ?