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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

HomePod review

Streaming : Netflix ou Amazon Prime Video ?