vba - Road Type Abbreviation Replacement in Excel -
i have large spreadsheet in excel has column of 6000+ addresses. want convert of road type abbreviations typed out types.
examples: rd -> road or st. -> street.
an issue i've encountered addresses contain sequence of letters trying replace , find , replace feature ends replacing parts of names of streets in addition replacing abbreviations.
for example: 1123 stupid state st replaced 1123 streetupid streetate street
is there way write code change abbreviations while preserving rest of address?
note: of addresses not follow same format. abbreviations fall in random places within cell--that abbreviations not appear @ end of cell value.
this needs work road type abbreviations.
thanks ton help.
i see tried find , replace, guessing did not check "match whole word" advanced option. find , replace again, click advanced button, , check "match whole word" checkbox. long abbreviations separated space street name, should replace abbreviation without touching street name.
Comments
Post a Comment