|
So, it looks like you are trying to make a one-time fix of the spreadsheet.
Are there any formulas you are trying to preserve or is this just a list of information? If there are no formulas, your fix is quite easy, especially since you only have five columns. In cell F1, type "=PROPER(A1)" with no absolute referencing. Copy that cell, highlight cells A1:E22000 and Paste. With those cells you just pasted still highlighted, choose Copy and then go to the Edit menu and choose "Paste Special..." (a favorite and underused command). In the resulting dialog box choose "Values." That will give a cleaned up database (and BTW: I taught you this command once before!!!).
If there are formulas involved, I will have to put a little more thought into it.
__________________
The thing about quotes on the internet is that you cannot verify their validity.- Abraham Lincoln
|