K
K8_Dog
In my data, I have some cells that end in " - " (space dash space). I would
like to delete the space dash space if it is the last thing in the cell. I
would like to keep it if it is in the middle. I know that the TRIM function
deletes a trailing space, can I edit it to delete a trailing space dash
space? Here's an example:
Mary - poodle
Theo - beagle
Barney -
Jacob - pug
Schmitty -
So, I want "Mary - poodle" to stay the same, and "Barney - " to become just
"Barney" like this
Mary - poodle
Theo - beagle
Barney
Jacob - pug
Schmitty
Thank you!
like to delete the space dash space if it is the last thing in the cell. I
would like to keep it if it is in the middle. I know that the TRIM function
deletes a trailing space, can I edit it to delete a trailing space dash
space? Here's an example:
Mary - poodle
Theo - beagle
Barney -
Jacob - pug
Schmitty -
So, I want "Mary - poodle" to stay the same, and "Barney - " to become just
"Barney" like this
Mary - poodle
Theo - beagle
Barney
Jacob - pug
Schmitty
Thank you!