Remove Part of text string

[erock24]

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.

[VBA Noob]

Maybe

Sub RemovePeriod()
Dim Lr As Long
Dim c As Range, Rng As Range
Lr = Cells(Rows.Count, "O").End(xlUp).Row
Set Rng = Range("O5:O" & Lr).SpecialCells(xlCellTypeConstants, 2)
For Each c In Rng
    If Right(c, 1) = "." Then
        c.Value = Mid(c, 1, Len(c) - 1)
    End If
Next c
End Sub

VBA Noob

[erock24]

Awesome!! it's perfect.