Excel LOWER Function
The Excel LOWER function converts all uppercase text in a specified text string to lowercase
Example: Excel LOWER Function
|
=LOWER("EXCELDOME")
|
Result in cell C5 (exceldome) - returns the specified text, which is all in uppercase, into lowercase.
|
|
=LOWER(B5)
|
Result in cell C5 (exceldome) - returns the specified text in cell (B5), which is all in uppercase, into lowercase.
|
METHOD 3. Excel LOWER function using the Excel built-in function library with hardcoded values
EXCEL
Formulas tab > Function Library group > Text > LOWER > populate the input box
| =LOWER("EXCELDOME") Note: in this example we are converting the specified text, which is all in uppercase, into lowercase. |
 |
METHOD 4. Excel LOWER function using the Excel built-in function library with links
EXCEL
Formulas tab > Function Library group > Text > LOWER > populate the input box
| =LOWER(B5) Note: in this example we are converting the specified text in cell (B5), which is all in uppercase, into lowercase. |
 |
Sub Excel_LOWER_Function()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("LOWER")
'apply the Excel LOWER function
ws.Range("C5") = LCase("EXCELDOME")
ws.Range("C5") = LCase("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 LOWER.
Worksheet Name: Have a worksheet named LOWER.
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_LOWER_Function()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("LOWER")
'apply the Excel LOWER function
ws.Range("C5") = LCase(ws.Range("B5"))
ws.Range("C5") = LCase(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 LOWER.
Text: Have the text which you want to convert to lowercase in cell ("B5").
Worksheet Name: Have a worksheet named LOWER.
Text: Have the text which you want to convert to lowercase 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 lowercase by changing the cell reference ("B5") to any range in the worksheet, that doesn't conflict with the formula.