You might have used the change case in Word 2007 either from the "Home" tab or by using the [Alt] + [F3] keys. This however doesn't work with Excel. But you can use certain text functions to do the same. To convert your text into sentence case, carryout the following steps:
o Presuming your source data is "Column A", go to the destination cell and type the formula as "=PROPER[A1)".
o Using the fill handle, drag the formula to the subsequent cells. Now since your formulas are dependent on the source data, you cannot delete it. But by using this formula, you have 2 sets of the same data.
Thus to remove these duplicate values, carry out the following steps:
Select the cells containing the formula.
o Go to the "Home" tab, and click the "Copy" option from the "Clipboard" group,
o Go to the original source cell range, click the small arrow appearing under the "Paste" option from the "Clipboard" group.
o Select "Paste SpeciaL .. ".
o In the "Paste Special" dialog box, check the "Values" option from the "Paste" section.
o Click "OK".
o Select the cell containing the "=PROPER[)" formula. Press the [Delete] key to delete duplicate values.