A familiar scene: you or a student have typed piles of information into an Excel spreadsheet in a natural combination of upper and lower case. Unfortunately it was required to be in upper case, or capitals, throughout. Hmmm. Don't start retyping - or, if the data was provided by someone else, moan at them in the hope they'll change it for you. Excel is smart and has a solution.

The quickest and easiest way to change the data is as follows:

1. Insert a new column next to the data to be modified.
2. If Bridge is in Cell A4, Place your Cursor in B4
3. Press your Paste function (fX) key
4. Select the Upper Function (In Text or All) and select OK
5. In the Box, type A4 or Select Cell A4 and Press OK. The Data in Cell B4 will be set to BRIDGE
6. Copy this formula through down column B next to the data to be changed.
7. Once column B has all of the correct data in Caps, Select Column B (highlight the column), Select Copy, Place the Cursor in B1, Select Paste Special and then Select the Values Radio Button. Select OK. This replaces the formulas in Column B to values.
8. Copy the Data in Column B to Column A and you are done.

Note: This should take less then a minute to make the changes. Good Luck.

There are also solutions for variations on the case theme. Ask for details.