Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel

Published by Get eSolutions on

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.

getesolutionsMACRO 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
getesolutionsRELATED VIDEO:

1 Comment

How to Save Macro Code Permanently in Excel… as part of the programme | Get eSolutions · March 21, 2019 at 2:07 pm

[…] Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel […]

Leave a Reply

Title