The site formerly known as Code For Excel and Outlook
October 8, 2010 by · 
Not sure if you knew about this, but in New York every street sign needs to be changed to proper case. At a cost of approximately $27 million, this expenditure is a symbol of government waste, and in New York that is saying something.
I think it's a ridiculous waste of taxpayer money, but a good opportunity to review some of the case changing features in Excel.
Continue Reading: A Case of a Headache »
June 18, 2009 by · A co-worker of mine came to me with a problem. Say you have a column with mixed upper and lower text, and wanted to switch everything to upper case. The slow way would be to add a helper column, painstakingly insert individual UPPER formulas next to each lower case cell, then individually paste values back into the original column.
Or just use the following formula (and method).
Continue Reading: Case changing and checking in Excel »
Site last updated: February 8, 2012
Follow Me