Trim

[rhockman]

How do I get just the Characters on the right side of the last underscore from this data?  BC.SOC123.1

BC_1960 America Section 1BC_BC.SOC123.1

[#2 · Accepted solution]

@rhockman 

With such a value in A2:

=TRIM(RIGHT(SUBSTITUTE(A2,"_",REPT(" ",255)),255))

This can be filled down if required.

[#3]

Thank you Hans!