Was wondering if someone could help me.
Was thinking something along the lines of the procedure below, but I only want to remove one space at the end of my text within a cell, if there is a space. Any quick ideas? Thx.
Was thinking something along the lines of the procedure below, but I only want to remove one space at the end of my text within a cell, if there is a space. Any quick ideas? Thx.
Code:
Sub hth()
Dim c As Range
For Each c In Range("H1", Range("H" & Rows.Count).End(xlUp))
c.Value = Trim(c.Value)
Next c
End Sub