Solve : Strange Excel Problem?

1.	Solve : Strange Excel Problem?
Answer» 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!!!! 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.

Discussion