Excel UPPER Function
The Excel UPPER function converts all lowercase text in a specified text string to uppercase
Example: Excel UPPER Function
|
=UPPER("exceldome")
|
Result in cell C5 (EXCELDOME) - returns the specified text, which is all in lowercase, into uppercase.
|
|
=UPPER(B5)
|
Result in cell C5 (EXCELDOME) - returns the specified text in cell (B5), which is all in lowercase, into uppercase.
|
METHOD 3. Excel UPPER function using the Excel built-in function library with hardcoded values
EXCEL
Formulas tab > Function Library group > Text > UPPER > populate the input box
| =UPPER("exceldome") Note: in this example we are converting the specified text, which is all in lowercase, into uppercase. |
 |
METHOD 4. Excel UPPER function using the Excel built-in function library with links
EXCEL
Formulas tab > Function Library group > Text > UPPER > populate the input box
| =UPPER(B5) Note: in this example we are converting the specified text in cell (B5), which is all in lowercase, into uppercase. |
 |
Sub Excel_UPPER_Function()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("UPPER")
'apply the Excel UPPER function
ws.Range("C5") = UCase("exceldome")
ws.Range("C5") = UCase("exceldome")
End Sub
OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
PREREQUISITES
Worksheet Name: Have a worksheet named UPPER.
Worksheet Name: Have a worksheet named UPPER.
ADJUSTABLE PARAMETERS
Output Range: Select the output range by changing the cell reference ("C5") in the VBA code to any cell in the worksheet, that doesn't conflict with formula.
Sub Excel_UPPER_Function()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("UPPER")
'apply the Excel UPPER function
ws.Range("C5") = UCase(ws.Range("B5"))
ws.Range("C5") = UCase(ws.Range("B5"))
End Sub
OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
PREREQUISITES
Worksheet Name: Have a worksheet named UPPER.
Text: Have the text which you want to convert to uppercase in cell ("B5").
Worksheet Name: Have a worksheet named UPPER.
Text: Have the text which you want to convert to uppercase in cell ("B5").
ADJUSTABLE PARAMETERS
Output Range: Select the output range by changing the cell reference ("C5") in the VBA code to any cell in the worksheet, that doesn't conflict with formula.
Text: Select the text which you want to convert to uppercase by changing the cell reference ("B5") to any range in the worksheet, that doesn't conflict with the formula.