Convert UPPERCASE to lower or Proper case without retyping
Stop the retyping and follow these steps. This is a two part process. First you will create a formula to convert the text then you will copy and paste the value into a new column.
1. Insert 2 blank columns to the right of the column in question (A). The example below shows column A in UPPERCASE column B and C are blank, column D has a location.
2. In this example a formula would be placed in the first cell to the right of the first name B2.
3. Type the following formula =Proper(A2) pressing enter will convert the UPPERCASE NAME to the proper case name. Example below shows both the formula and the proper case name.
4. Now using the Autofill handle in the lower right hand corner of B2 click hold and drag this down the column to copy the formula that converts the character case. DO NOT DELETE COLUMN A at this time.
5. Now that column B has the proper case displayed you must copy Column B and paste it into column C using Paste Special. Reminder: Column B is only displaying a value of a formula not the actual text. Click on the column heading B to select the column. Copy using CTRL+C or the copy icon.
6. Paste Special: Right mouse click in cell C2, then select Paste Special from the quick menu. The Paste Special dialog box will appear.
7. Click on the radio button for Values. This will paste the value of the convert formula into column C.
8. If Column C looks correct you can now delete Column A and B.
Note: There are two other formulas that change case as well: =UPPER(cell) will convert to all upper case characters. =LOWER(cell) will convert to all lower case characters. Replace (cell) with the actual cell location.