Relpace entire address with street name only, searching with wildc

[Guest]

I have a database with addresses that are the same, but entered differently.
ie, 123 Main Street, Suite 100; 123 Main St., Ste 100.; 123 Main Street, Ste
100

I need to replace any address containing "Main" with the text "Main".

 

[Guest]

You should be able to do this with Find/Replace. Select your range of
addresses. Then from the Edit Menu, select "Replace..."

In the Find what field enter: *main*
In the Replace with field enter: main

Click Replace All. That should do it.

HTH,
Elkar

 

[oldchippy]

Hello bclancy12,

Why not try Find > Replace

ie. Find "Main Street" then Replace "Main"

then Find "Main Ste" then Replace "Main"

oldchippy

 

[Guest]

That works, I was missing the second * after "main" so it was leaving the
rest of the address there. I was hoping there was a formula that I could use
so that this would be a little bit less manual, but this will work. Thanks!!