filmov
tv
Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel
Показать описание
How to enable Change case (Lowercase, Uppercase, Proper case letters) in MS-Excel 2007, 2010, 2013 & 2016 Without Formula using Macro code (VBA-Visual Basic Editor)
--------------------------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 Videos----------------------
--------------------------My Stuff-----------------------
--------------------------Follow us-----------------------
Keep Watching, Keep learning...!!!
-~-~~-~~~-~~-~-
Please watch: "How to Use Macro in Excel | How to Create Macros in Excel | Macro Record kaise kare | Macro in Excel"
-~-~~-~~~-~~-~-
--------------------------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 Videos----------------------
--------------------------My Stuff-----------------------
--------------------------Follow us-----------------------
Keep Watching, Keep learning...!!!
-~-~~-~~~-~~-~-
Please watch: "How to Use Macro in Excel | How to Create Macros in Excel | Macro Record kaise kare | Macro in Excel"
-~-~~-~~~-~~-~-
0:00:55
Quick Way To Change Text Case in Excel Without Formula - Excel Tutorials
0:01:19
Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel
0:07:56
Easily Change CASE of Text in Excel (3 ways including NO Formulas)
0:05:37
Excel Change Case With or Without Formula - Upper, Lower, Title Case
0:00:28
How to convert Capital Letters to Small letters in excel without any formula #exceltutorial
0:00:37
How to make an entire column capital or lowercase in Excel
0:00:48
How to Convert Lower Case text into Upper Case in Excel
0:01:07
How to Change Caps to Lowercase in Excel
1:03:30
2024 Tax Rules and Regulations Changes Businesses Should Know
0:00:45
How to Change Lowercase to Uppercase in Excel
0:03:01
How to Change Small letter to Capital letter in MS Excel (Upper Case/Lower Case)
0:00:44
convert to uppercase in excel | EXCEL
0:02:07
How to Automatically Convert to Proper Case as You Type in Excel
0:06:37
How To Change Case of Text in Excel Without Formulas || Convert Text In UPPER, LOWER & PROPER Ca...
0:01:29
How to Convert a Column to All Caps in Excel
0:01:49
How to Change Uppercase Letter to Lowercase in Excel
0:00:42
Excel First Letter Capital☺️| Proper Case in Excel #shorts #exceltips
0:08:47
Change CASE in Excel (5 ways including NO Formulas)
0:12:08
1 Click to Change Excel Text Case (Add Commands in Ribbon to Change Text Case)
0:06:56
Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel
0:01:00
Use Proper Upper Lower | Change Case in Excel | Sentence Case
0:01:55
How to Automatically Convert to Uppercase as You Type in Excel
0:05:35
Convert to Uppercase in Excel 2013
0:00:46
How to capitalize all the words in a cell in excel
Комментарии