View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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