Populate a Cell Based on Part of Another Entry...

[SMAsh67]

This works perfectly for populating a cell with everything left of the first _.

=IFERROR(LEFT(B11,FIND("_",B11)-1),"")

I was wondering, is there a way to make it show everything after the last "_"? I've been messing with it but I just can't get it to work.


The file names are never the same length. For example:


random name_17075496309_9863-7-3_9-36-27_GMC
thisone here_98634961630_1213-9-10_11-53-59_NC


But they always have 4 underscores. What is after the last underscore varies from 2 to 3 letters.


Some help would be greatly appreciated!

 

[JeanKim]

=right(a1,len(a1)-find("~",substitute(a1,"_","~",len(a1)-len(substitute(a1,"_","")))))

or

=TRIM(RIGHT(SUBSTITUTE(A1,"_",REPT(" ",99)),99))

 

[SMAsh67]

I am using the second solution you gave me, thank you! It works perfectly