Find and Replace Macro

J

Josh O.

I am trying to make a Macro that searches addresses in a worksheet and
replaces "street" abbreviations with fully spelled out words. I have the
general idea of how to make the macro, but I have a couple of selective
replacements that I don't know how to handle

For example, I need to be able to replace "Dr" in "123 Monroe Dr", with
"Drive" to make "123 Monroe Drive". But I need to make sure that "Dr." in
"Dr. Bill Excel doesn't get replaced and make "Drive. Bill Excel".

The address column will be in different columns depending on which report is
being run. And there is no space or other character after "Dr" in the
address.

If I get this figured out, I should be able to solve my other problems. Any
ideas?
 
M

Mike Q.

Monroe Dr. has a space in front of the D
Dr. Bill Excel Dosen't (maybe)
Would a search for (space)Dr. Help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and replace macro for Special ^p - MS Word 0
Word macro that can call cells out of Excel for a find and replace 0
Removing a repeated words 0
Macro to delete duplicate cell 1
Extract name, address and ph# 8
Improving Macro That Keeps First Letter 0
Help on reversing data 3
Merging two cells within the same table 3

Top