Excel VBA's Missing String Functions

Excel VBA's Missing String Functions

DOWNLOAD THE CODE: Get the source code for this video here: (https://bit.ly/2t335rQ)

SUBSCRIBE TO THE CHANNEL: https://bit.ly/36hpTCY

Excel VBA Training
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)
Webinar Archives - 60+ Hours of VBA training(https://excelmacromastery.com/excel-vba-webinars/)

Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vba-articles/)

Related Links:
Instr function (https://bit.ly/2TnUQBr)
Replace function (https://bit.ly/2sgOyrW)
String function (https://bit.ly/36NOO0I)

USEFUL SHORTCUT KEYS
====================
Cool Tricks:
Ctrl + Space: Auto complete word.
Shift + F2: Get the definition of the item under the cursor.
Ctrl + Shift + F2: Go to the last cursor position.
Ctrl + Shift + 8(or Ctrl + *): Get the current region on a worksheet.
Alt + F11: Switch between Excel(or any Office Application) and the VBA Editor.

Running and Debugging:
F5 Run the code from the current sub.
F8: Step into the code line by line. Enter a sub that is called.
Shift + F8: Step through the code but don't enter a sub that is called.
Alt + D + C OR Alt + D + Enter: Compile the code.
F9(or click left margin): Add a breakpoint to pause the code.

Windows:
Ctrl + G: View the Immediate window.
Alt + V + H: View the Watch window.
Ctrl + R: View the Project Explorer window.
F4: View the Project properties window
F7: Switch to code view when the UserForm is visible.

Formatting:
Tab: To move lines of code to the right(Indent).
Shift + Tab: To move lines of code to the left(Outdent).

Table of Contents:

00:00 - Introduction
00:31 - Marker 1