removing first word from a string

[merryperson]

I wish to catalogue my albums but when they are in excel they are shown by the track number first
06 Killer Queen
02 Spirit in the sky
96 life on mars
Some are even shown as
1-01 sweet Love
2-02 Strut your funky stuff
I wish to remove the fist word in the string and report just the song title without the track number
ie killer Queen
Spirit in the Sky

Anybody help please

 

[mikerickson]

Try something like

=IF(CODE(A1) < 65, TRIM(MID(SUBSTITUTE(A1, " ", REPT(" ",255), 1), 255, 255)), TRIM(A1))

 

[gaz_chops]

Try

=SUBSTITUTE(A1,LEFT(A1,FIND(" ",A1)),"")

(Good music choice )

 

[Rick Rothstein]

Assuming there are never any spaces around the dashes within the first numbers, and assuming no song title is more than 99 characters long, this formula should work for you...

=MID(A1,FIND(" ",A1)+1,99)

 

[merryperson]

Brilliant many thanks