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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does anyone have an excel macro that converts states to 2 digit f.
This is a million requests in one. Each example you cite is a different
piece of code, and no doubt you have a hundred more. You need to prioritise and tackle one at a time, building it up piece by piece. And you refer (darkly :-)) to '... current macro makes all these errors ...' so it sounds as if you need to incorporate it in there or update that code. It sounds to me like you need to write a spec and hire someone. -- HTH RP (remove nothere from the email address if mailing direct) "Bryghtfalcon" wrote in message ... 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 |
Reply |
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 |