How do I remove a period from the end of a string of text

[Jeff M]

I have a column of data, some of which the text ends with a period, the other has the text, a period, then another string of text with no spacing. I want to remove the period from the string of text ONLY if there is no text after the period. Thoughts?

Thanks!

[shg]

Try this:

=if(right(a1)=".", left(a1, len(a1)-1), a1)