Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel
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
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 […]