Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel
108.2 هزار بار بازدید -
7 سال پیش
-
How to enable Change case
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---------------------
►[✌Types] Create Drop Down List in Excel | Make drop down list in excel | Excel drop down list: [✌Types] Create Drop Down List in Exc...
►⚡Use Flash Fill for MAJOR Time Saving in Excel | Split cells | Combine Cells | Change Case in Excel: ⚡Use Flash Fill for MAJOR Time Saving...
►Text Filter in Excel | Excel advanced filter contains text: Text Filter in Excel | Excel advanced...
►[VLOOKUP explained] VLOOKUP formula in Excel with example | VLOOKUP example between two sheets: [VLOOKUP explained] VLOOKUP formula i...
►[Trim Function] How to remove extra spaces in MS-Excel | Remove blank spaces in excel: [Trim Function] How to remove extra s...
►[Datedif Excel] How to calculate date difference in Excel | Excel Date Difference: [Datedif Excel] How to calculate date...
►[Easy Way] How to Convert Row to Column in excel (Vertical to Horizontal) | Transpose Data in Excel: [Easy Way] How to Convert Row to Colu...
►How to Save Macro Code Permanently in Excel… as part of the programme: How to Save Macro Code Permanently in...
►How to Print Odd Or Even Pages In Excel 2007, 2010, 2013 & 2016: How to Print Odd Or Even Pages In Exc...
►How to insert/add watermark in MS-Excel 2007, 2010, 2013 & 2016 | how to put watermark in excel: How to insert/add watermark in MS-Exc...
►How to Convert Excel (.csv) to .vcf file Directly | csv to vcf | Excel to vcf converter: How to Convert Excel (.csv) to .vcf f...
►How to Import Unlimited Contact From Excel to Mobile: How to Import Unlimited Contact From ...
►How to Print Long Sheet in Minimum Page (Excel Page Setup & Print): How to Print Long Sheet in Minimum Pa...
►How to Find & Remove Duplicates in Excel | Highlight Duplicates in Excel: How to Find & Remove Duplicates in Ex...
►How to Combine text from two or more cells into one cell in MS Excel: [Concatenate Excel] How to Combine te...
►How to Convert Numbers to Words in Excel: Convert Number to Words in Excel 2010...
-------------------------My Stuff----------------------
►Know all about Bitcoin in Hindi (What is Bitcoin? How to Buy & Sell? free bitcoin? Bitcoin Wallet?): Know all about Bitcoin in Hindi (What...
►Aadhar Card Complete details videos: https://goo.gl/QqVqok
►Facebook Tips & Tricks (Advance): https://goo.gl/p71qH9
►The fastest way to type/Convert Documents: https://goo.gl/QmR1yp
►MS-Excel Tutorials (Advance): https://goo.gl/AeYmQh
►Ms-Word Tutorials (Advance): https://goo.gl/gTC98G
►MS-PowerPoint Tips & Tricks (Advance): https://goo.gl/5E9NQS
►WhatsApp Tips & Tricks (Advance): https://goo.gl/axGsrR
►Top Windows Tips & Tricks: https://goo.gl/xjdWKQ
►Best Browser Apps or Extensions: https://goo.gl/vXuGFj
►View Saved Password in Computer & Mobiles: https://goo.gl/t7tPWA
►Most Useful Payment Apps: https://goo.gl/WcjdYX
►Best Android Mobile Tips & Tricks: https://goo.gl/jsKZUu
►Best & Useful Mobile Apps: https://goo.gl/MisLov
►1935 error | Filmora install stuck at 0 | PCL XL Error: https://goo.gl/zz6jBZ
-------------------------Follow us----------------------
►For more videos Updates please Subscribe our Youtube Channel (Get eSolutions) - getesolutions
► Facebook: www.facebook.com/getesolutions
► Twiter: twitter.com/getesolutions
► Website : http://getesolutions.com
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"
How to Use Macro in Excel | How to Cr...
~-~~-~~~-~~-~
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
►[✌Types] Create Drop Down List in Excel | Make drop down list in excel | Excel drop down list: [✌Types] Create Drop Down List in Exc...
►⚡Use Flash Fill for MAJOR Time Saving in Excel | Split cells | Combine Cells | Change Case in Excel: ⚡Use Flash Fill for MAJOR Time Saving...
►Text Filter in Excel | Excel advanced filter contains text: Text Filter in Excel | Excel advanced...
►[VLOOKUP explained] VLOOKUP formula in Excel with example | VLOOKUP example between two sheets: [VLOOKUP explained] VLOOKUP formula i...
►[Trim Function] How to remove extra spaces in MS-Excel | Remove blank spaces in excel: [Trim Function] How to remove extra s...
►[Datedif Excel] How to calculate date difference in Excel | Excel Date Difference: [Datedif Excel] How to calculate date...
►[Easy Way] How to Convert Row to Column in excel (Vertical to Horizontal) | Transpose Data in Excel: [Easy Way] How to Convert Row to Colu...
►How to Save Macro Code Permanently in Excel… as part of the programme: How to Save Macro Code Permanently in...
►How to Print Odd Or Even Pages In Excel 2007, 2010, 2013 & 2016: How to Print Odd Or Even Pages In Exc...
►How to insert/add watermark in MS-Excel 2007, 2010, 2013 & 2016 | how to put watermark in excel: How to insert/add watermark in MS-Exc...
►How to Convert Excel (.csv) to .vcf file Directly | csv to vcf | Excel to vcf converter: How to Convert Excel (.csv) to .vcf f...
►How to Import Unlimited Contact From Excel to Mobile: How to Import Unlimited Contact From ...
►How to Print Long Sheet in Minimum Page (Excel Page Setup & Print): How to Print Long Sheet in Minimum Pa...
►How to Find & Remove Duplicates in Excel | Highlight Duplicates in Excel: How to Find & Remove Duplicates in Ex...
►How to Combine text from two or more cells into one cell in MS Excel: [Concatenate Excel] How to Combine te...
►How to Convert Numbers to Words in Excel: Convert Number to Words in Excel 2010...
►Know all about Bitcoin in Hindi (What is Bitcoin? How to Buy & Sell? free bitcoin? Bitcoin Wallet?): Know all about Bitcoin in Hindi (What...
►Aadhar Card Complete details videos: https://goo.gl/QqVqok
►Facebook Tips & Tricks (Advance): https://goo.gl/p71qH9
►The fastest way to type/Convert Documents: https://goo.gl/QmR1yp
►MS-Excel Tutorials (Advance): https://goo.gl/AeYmQh
►Ms-Word Tutorials (Advance): https://goo.gl/gTC98G
►MS-PowerPoint Tips & Tricks (Advance): https://goo.gl/5E9NQS
►WhatsApp Tips & Tricks (Advance): https://goo.gl/axGsrR
►Top Windows Tips & Tricks: https://goo.gl/xjdWKQ
►Best Browser Apps or Extensions: https://goo.gl/vXuGFj
►View Saved Password in Computer & Mobiles: https://goo.gl/t7tPWA
►Most Useful Payment Apps: https://goo.gl/WcjdYX
►Best Android Mobile Tips & Tricks: https://goo.gl/jsKZUu
►Best & Useful Mobile Apps: https://goo.gl/MisLov
►1935 error | Filmora install stuck at 0 | PCL XL Error: https://goo.gl/zz6jBZ
►For more videos Updates please Subscribe our Youtube Channel (Get eSolutions) - getesolutions
► Facebook: www.facebook.com/getesolutions
► Twiter: twitter.com/getesolutions
► Website : http://getesolutions.com
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"
How to Use Macro in Excel | How to Cr...
7 سال پیش
در تاریخ 1396/08/06 منتشر شده
است.
108,212
بـار بازدید شده