How do I replace just a few characters?

[Tomsriv]

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?

 

[Bearacade]

Do exactly what you are doing. .but instead of pressing replace, press
replace all.

BTW.. do a replace on "STREET" with "ST"

 

[Gord Dibben]

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

 

[Tomsriv]

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 wit
space rd " RD"then it will always find it because their is always
space between the street name and the suffix