I need a macro to remove the period at the end of my text string in Range O5:down. I have other periods in the text string that need to remain. Only remove the last one. Is this possible?

thank you.