Trim Characters Other Than An Empty Space At The End Of A Cell
 

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!

Trim Characters Other Than An Empty Space At The End Of A Cell
 

With data in Column A, try this in B1:

=IF(RIGHT(A1,3)=" - ",LEFT(A1,LEN(A1)-3),A1)

And copy down as needed.

To remove the formulas and leave the data behind, copy Column B,
then Paste Special, Values, <OK, <Esc.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"K8_Dog" wrote in message
...
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!

Trim Characters Other Than An Empty Space At The End Of A Cell
 

Put this formula in an adjacent column:

=IF(RIGHT(A1,3)=" - ",LEFT(A1,LEN(A1)-3),A1)

Then copy this down as required.

Hope this helps.

Pete

On Apr 18, 11:31*pm, K8_Dog wrote:
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!

Trim Characters Other Than An Empty Space At The End Of A Cell
 

If your cells end with " - ", space-dash-space then:

=IF(RIGHT(A1,3)=" - ",LEFT(A1,LEN(A1)-3),A1)

"K8_Dog" wrote in message
...
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!

Trim Characters Other Than An Empty Space At The End Of A Cell
 

Thanks everyone,
This solution is perfect. LEN is new to me and so cool!
Thanks,
K8Dog

"Tyro" wrote:

If your cells end with " - ", space-dash-space then:

=IF(RIGHT(A1,3)=" - ",LEFT(A1,LEN(A1)-3),A1)

"K8_Dog" wrote in message
...
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!

Trim Characters Other Than An Empty Space At The End Of A Cell
 

And we appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"K8_Dog" wrote in message
...
Thanks everyone,
This solution is perfect. LEN is new to me and so cool!
Thanks,
K8Dog

"Tyro" wrote:

If your cells end with " - ", space-dash-space then:

=IF(RIGHT(A1,3)=" - ",LEFT(A1,LEN(A1)-3),A1)

"K8_Dog" wrote in message
...
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!