Computer Hope
Software => Computer software => Topic started by: kelleychambers on July 12, 2005, 03:02:24 AM
-
Ok, I admit this is a weird one. I am manually deleting duplicate contact records from a CSV file in Excel. Ok, I was trying to REPLACE ALL in a specific column where I needed no extra spaces but instead of the one column it replaced everything!!! Without knowing, I saved the file...
So my question here is how do I get the spaces back where they're needed like in the Address Field, Company Name field, etc.? Is there a macro I can do? If so, how? Most of the fields are in title case... which helps show distinction.
HELP!!! It's due back to my client tomorrow!!!! ??? :o
-
A macro would have been helpful for deleting the duplicate records in the first place. Since it' too late for UNDO, you might be able to write a macro provided there is a way programatically distinguish title case. Check out the Excel help screens.
These sites may be helpful or give you some ideas.
http://www.microsoft.com/technet/scriptcenter/resources/officetips/archive.mspx
http://spreadsheets.about.com/cs/excelfunction1/qt/qtexchangecase.htm
Since this seems to be a work environment, maybe there is a backup copy of the XLS file.
Good luck. 8)