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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?