Brand new to VBA. I've been asked to develop macros to clean up Excel's PROPER function on mailing lists. I'm almost done but I'm stuck on how to tell Excel to replace the last 3 characters only of the following street address:
400 W Selby Ave Se 'The Se at the end should be SE
My code (from the macro recorder)
changes Selby to SElby as well as Se to SE.
I'm hoping this is an easy solution.
Note: I have Ne, Nw and Sw to deal with also.
Thanks
400 W Selby Ave Se 'The Se at the end should be SE
My code (from the macro recorder)
Code:
Sub AddressFix()
Columns("N:N").Select
Selection.Replace What:=" Se", Replacement:=" SE", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
I'm hoping this is an easy solution.
Note: I have Ne, Nw and Sw to deal with also.
Thanks