delete a - if it is the last part of a string

[deb]

How can I delete a - if it is the last part of a string.

I have other - in the string but I only want to delete it if it is the last
character.

Thanks in advance!!

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete