Macro for converting Text into Lower, Upper and Proper Case
Please watch: "25 Advanced Excel Shortcuts"
• 25 Advanced Excel Shortcuts -~-
3 Macros for converting text cases are explained in this video. The advantage of using these macros is that you can convert data of any size (n number of columns & rows) into any of the 3 cases (Lower, Upper & Proper) in a single click.
Topics Discussed
1. LCase Function in VBA which is similar to Lower function in Excel
2. UCase Function similar to Upper function
3. Proper Function similar to Proper function
Would you like to receive A Notification as soon as I upload a Video?
If so 'Subscribe' to my Channel and press the 'Bell' Icon
https://bit.ly/2qvP29e
Check out my videos on VBA for Excel
1. How to create an Input Box using VBA for MS Excel
• How to create an Input Box in Excel u...
2. How to export data into Text File using Output / Append functions in VBA (write to text file)
• How to Export data from Excel to Text...
3.How to Read Data from a Text File or Files and import into Excel Workbook
• How to Import data from a Text File i...
Check out my videos on VBA for AutoCAD
1. Introduction to VBA for AutoCAD
• Introduction to VBA for AutoCAD
2. How to write a Script File for Creating a Line, Circle, Layer and Inserting Text in AutoCAD
• Video
Check out my video on How to convert PDF file into Word, Excel or JPEG format
• How to convert PDF file into Word or ...
Hit the Subscribe Button and Stay tuned for updates.
Thanks for watching :)
#LCaseFunction #UCaseFunction #ProperFunction
I strongly recommend TubeBuddy for upcoming Youtubers
https://www.tubebuddy.com/ajayanand
Disclaimer :
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
My Gear
Microphone : https://amzn.to/2QRpEFK
Headset : https://amzn.to/2CoKSp6
