How to extract everything but the first 8 characters

[Burrgogi]

This is probably basic for some of you but I'm stumped on how to do the following:

In column A, I've got the following:

5419754_Saturn_s.jpg
4987742_Saturn_2_s.jpg
4948559_Jupiter_s.jpg
3497741_Jupiter_2_s.jpg

so on & so forth...

What I'm trying to do is extract everything after the first underscore so that column B looks like the following:

Saturn_s.jpg
Saturn_2_s.jpg
Jupiter_s.jpg
Jupiter_2_s.jpg

The number at the beginning is always the same length - 7 digits long.
I have 'Googled' my around this and played around a little bit with the left & right functions... but haven't found an answer. The tips outlined in this website are very helpful tips but I haven't found a way to modify the functions to suit my specific situation. Any help would be appreciated.

 

[Peter_SSs]

Try
=REPLACE(A2,1,8,"")

That linked page is not directly relevant to you since you DO know the start point of what you want. If the number of digits varied but the underscore was always there then:

=REPLACE(A2,1,FIND("_",A2),"")

 

[Burrgogi]

Never thought of using the replace function. That is cool! I appreciate the answer Peter, tyvm.

 

[Weaver]

=MID(A2,8,255)

ought to work too.

Always more than 1 way to skin the proverbial cat in Excel.

 

[Peter_SSs]

=MID(A2,8,255)

ought to work too.

Provided the 8 was changed to a 9.

 

[Norie]

Perhpas you could try =RIGHT(A1, LEN(A1)-8) as well.

 

[Armando Montes]

Also Find and Replace

 

[Peter_SSs]

Perhpas you could try =RIGHT(A1, LEN(A1)-8) as well.

Sure, but I wouldn't have thought using 2 functions when 1 will do would be an efficient choice.

Also Find and Replace

To do this task, what would you envisage putting in the 'Find what:' box?