I deal with huge ranges of data daily. We have a "proper text" macro, but
that capitalizes everything, and changes acronyms and two digit state
abbreviations to upper and lower case. I need a macro that will run proper
text on names, changes "california" to "CA", does NOT change "12th" to 12Th",
Changes "Lane" and "Road" to "Ln" and "Rd" without changing words like
"Fairlane" and "Roades" to "FairLn." and "Rd.es". Our current macro makes
all these errors, so it takes almost as much time to clean up after running
it as it does to scrub the raw data.

I'd appreciate any help.

Thx,
Bryghtfalcon