Forum Discussion
Solved
Trim
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
With such a value in A2:
=TRIM(RIGHT(SUBSTITUTE(A2,"_",REPT(" ",255)),255))
This can be filled down if required.
With such a value in A2:
=TRIM(RIGHT(SUBSTITUTE(A2,"_",REPT(" ",255)),255))
This can be filled down if required.
Thank you Hans!