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!
