Hi,

I'm looking for help on creating a macro to parse addresses and text in a cell or a selected range of cells. The addresses come in various ways for example:

123 Main Street
123 Main St.
123 South Main Street
123 So. Main St.
123 NW Main Avenue

I would like a macro that will change the addresses to the following format:

123 Main St
123 S Main St
123 NW Main Ave

I would like to set up a Find and Replace macro to correct these addresses. I have not worked much with macro's so I'm at a loss as to what to do. Must be able to do this by cell or selected cell range, there is other information in the worksheet that doesn't need to be manipulated. The data that needs to change is the shipping addresses. Would like to be able to do the same with State Abbreviations. I have a macro for the States, but it runs through the whole worksheet. I just need it to be cell specific.

I would greatly appreciate any help!