Excel Find & Replace Last n Characters in a Cell 2

[Pugman]

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)

Sub AddressFix()
    Columns("N:N").Select
    Selection.Replace What:=" Se", Replacement:=" SE", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
        ReplaceFormat:=False
End Sub

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

 

[SkipVought]

Good one PHV. I missed that!

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]