SOLVED

Trim

Contributor

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 Replies
best response confirmed by rhockman (Contributor)
Solution

@rhockman 

With such a value in A2:

 

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

 

This can be filled down if required.

Thank you Hans!