VBA Return Last Text from a String

[decadence]

Is it possible to get the variable last text in a string after an underscore. There will always be an underscore before the last word but the length of the text is variable and the text contains letters and numbers. I would like to offset the returned text i.e C2 contains the text and G2 is where I would like to return the last text of the string. Can someone help with this please

 

[vds1]

Assuming the value is in cell A1 then you may try this below VBA code in immediate window:

split([A1],"_")(len([A1])-len(replace([A1],"_","")))

or

split([A1],"_")(ubound(split([A1],"_")))

 

[steve the fish]

Or a formula:

=TRIM(RIGHT(SUBSTITUTE(C2,"_",REPT(" ",LEN(C2))),LEN(C2)))

 

[Rick Rothstein]

Assuming the value is in cell A1 then you may try this below VBA code in immediate window:

split([A1],"_")(len([A1])-len(replace([A1],"_","")))

or

split([A1],"_")(ubound(split([A1],"_")))

Or...

Mid([A1], InStrRev([A1], "_") + 1)