Greetings, I'm trying to determine how I can omit trailing values of a column. Further, I'm not able to use the val() function due to the preceding numbers are typically 20 characters long, but can be as little as 15 characters.
Ex:
12345-
1234
12345
123-
1-
1
In sum, I need to keep the values less the trailing hyphen. Is there a simple way to accomplish?
Thanks!
Ex:
12345-
1234
12345
123-
1-
1
In sum, I need to keep the values less the trailing hyphen. Is there a simple way to accomplish?
Thanks!