delete a - if it is the last part of a string
Try this:
=IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1),A1)
Hope this helps.
Pete
On Sep 21, 1:11*am, deb wrote:
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!!
--
deb
|