Excel 'Proper' Formula

Kevy Baby · 03-27-2005, 06:23 PM

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.

03-27-2005, 06:23 PM	#1
Kevy Baby Chowder Head Join Date: Jan 2005 Location: Yes Posts: 18,500	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
	Submit to Quotes