Macro Question
Dim Cell As Range
For Each Cell In Range("A:A")
If Cell < "" Then Cell = Left(Cell, Len(Cell) - 1) & UCase(Right(Cell, 1))
Next Cell
(Adjust your range accordingly)
"ALoecher" wrote:
I am working with a very large sheet that lists addresses. However the state
code is listed with one upper and one lowercase letter. I want to design a
macro to replace only the last letter with its uppercase equivelant.
eg
Santa Ana Ca
to
Santa Ana CA
|