Every time we need to change the desired matter or text in Lowercase, Uppercase, Proper case letters in Excel. Unfortunately, MS-Excel doesn’t have important change case feature like MS-Word. 

In this video, you will learn to enable Change case feature without formula. Just need to use macro code (VBA-Visual Basic Editor). The best thing is that it will change our desired content without disturbing our data. So now no need to insert a temporary column in our sheet.

MACRO CODE:

Sub ChangeTextCase()
Dim strChange As String
strChange = InputBox("Type l, u, or p to change case:" & vbCr & vbLf & vbCr & vbLf & _
"Lowercase = l, uppercase = u, proper case = p", "Change case of selected cells", "")
Select Case strChange
Case "l", "L"
For Each x In Application.Selection
x.Value = LCase(x.Value)
Next
Case "u", "U"
For Each x In Application.Selection
x.Value = UCase(x.Value)
Next
Case "p", "P"
For Each x In Application.Selection
x.Value = WorksheetFunction.Proper(x.Value)
Next
Case Else
MsgBox "Type l, u, or p." & vbCr & vbLf & vbCr & vbLf & "Click OK to start over."
End Select
End Sub

RELATED VIDEO: