Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does anyone have an excel macro that converts states to 2 digit f.
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Excel 2007 data by states using United States (US) map | Excel Discussion (Misc queries) | |||
Macro that converts xls to csv | Excel Worksheet Functions | |||
When I enter a date in Excel it converts to a 5-digit number. WHY? | Excel Discussion (Misc queries) | |||
Excel converts 9-digit string to sci. not. when saved as csv | Excel Discussion (Misc queries) | |||
Help - This macro converts my text numbers. | Excel Programming |