Change uppercase to lowercase
To change uppercase into lowercase for a specific text sting we need to apply the Excel LOWER function
Example: Change uppercase to lowercase
|
=LOWER(B5)
|
The formula uses the Excel LOWER function to return the specified text in cell B5, which is all in uppercase, in lowercase.
|
Sub Change_uppercase_to_lowercase()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'apply the formula to change uppercase to lowercase
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 Analysis.
Text: Have the text which you want to convert to lowercase in cell ("B5").
Worksheet Name: Have a worksheet named Analysis.
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.