Strange Excel Problem

[kelleychambers]

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!!!!  

[Sidewinder]

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.