Sometimes you get a Powerpoint deck featuring graphs and tables inserted via embedding an excel workbook. Of course, this is pretty stupid as the recipient…
I’m not sure where I got the following file (a quick Google didn’t reveal much) but it is incredibly useful. It takes “short” form data…
http://msdn.microsoft.com/en-us/library/cc837974(v=office.12).aspx http://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx
This tests to see if a cell is ALL UPPER CASE. If so, it replaces the cell with “UpperCase”. If not, it replaces the cell…