Another Find and Replace macro help please!
Posted by TJ on December 07, 2001 9:11 AM
I have a text file extracted from a CRM database that contains multiple instances of data that I need to replace. It spans over 25+ columns within excel and each column will contain unique data that needs to be replaced.
An example would be the address field. Two such replacements that I need to make are "St." or "St" to equal "STREET". There are many similar instances with things like "Ave", "Blvd","N.","S.","E.","W.", ect. I want to make everything comply with the USPS standards.
The next column will have another set of unique data to replace.
I know there has to be a simple solution to this, but I haven't been able to perform this in a more efficient manner.
THANK YOU FOR ANY HELP IN ADVANCE!