Excel question

  rawsongreen 14:57 06 Feb 2010
Locked

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

=RIGHT(A1,LEN(A1)-2)

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

Intel Coffee Lake release date and specifications

12 Amazing British Craft Beer Label Designs

watchOS 4 review

Les meilleurs navigateurs internet 2017