How do I replace just a few characters?

Hello,
I have an excel worksheet with a street name column. I need to rename some names from "Main Street" to "Main St". I can do it for one name easily with find and replace, but how do I make it work for an entire column of different names such as "Easy Street" and "Main Street". If I do find "* Street" and replace with "* ST" I get "* ST" for the output instead of "Easy ST"

What am I missing?

Don't use the wildcard.

Select the column and.......

Replace what: Street

Replace with: St.

Works for me with a column of Main Street, Easy Street and similar.

If you have a name like Street Street I don't know<g>


Gord Dibben MS Excel MVP


On Mon, 14 Aug 2006 18:37:49 -0400, Tomsriv
<[email protected]> wrote:

>
>Hello,
>I have an excel worksheet with a street name column. I need to
>rename some names from "Main Street" to "Main St". I can do it for one
>name easily with find and replace, but how do I make it work for an
>entire column of different names such as "Easy Street" and "Main
>Street". If I do find "* Street" and replace with "* ST" I get "* ST"
>for the output instead of "Easy ST"
>
>What am I missing?

Thanks for the quick reply

When I say replace all it doesn't work for different names.
But I found a work around. If I do space road " ROAD", replace with space rd " RD"then it will always find it because their is always a space between the street name and the suffix.