Excel question

  rawsongreen 14:57 06 Feb 10
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 10

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 10

Vog once again you are brilliant.
Many thanks.

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Apple MacBook Pro with Touch Bar review

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…