Convert cell value to UPPERCASE or lowercase..

    Browse: Home / Convert cell value to UPPERCASE or lowercase..

For all of the following examples, let’s pretend we have ‘CHOcolate’ in cell A1:

If you would like the text to appear in Upper Case
Type the formula: =Upper(A1) into cell B1, and the text will appear as: CHOCOLATE

If you would like the text to appear in Lower Case
Type the formula =Lower(A1) into cell B1, and the text will appear as: chocolate

If you would like the text to appear in Lower Case, with the first Letter as a Capital
Type the formula: =Proper(A1) into cell B1, and the tekst will appear as: Chocolate

If you want to process as bulk, using VBA:

Select a range and run the macro. If no range is selected, the entire sheet is processed.

 

Sub UpperCase()
Dim cell As Excel.Range

For Each cell In Selection.SpecialCells(xlTextValues, 2)
    cell.Value = Ucase$(cell.Value)
Next cell

End Sub

Sub LowerCase()
Dim cell As Excel.Range

For Each cell In Selection.SpecialCells(xlTextValues, 2)
    cell.Value = Lcase$(cell.Value)
Next cell

End Sub

Sub Proper()
Dim cell As Excel.Range

For Each cell In Selection.SpecialCells(xlTextValues, 2)
    cell.Value = WorksheetFunction.Proper(cell.Value)
Next cell

End Sub

Source: http://www.codeforexcelandoutlook.com/blog/

«
»