The Ultimate Excel VBA Course - Learn and Master VBA Fast - The Left and Right Functions

The video tutorial explains how to use the left and right functions in VBA to manipulate strings by extracting characters from the start or end. It provides a practical example using an email address and demonstrates more complex usage by reordering names. The tutorial covers initializing variables, using the inStr function to find spaces, and extracting first and last names. It concludes with a final code example that displays the reordered name in a message box.

What is the primary purpose of the left function in string manipulation?

• To extract characters from the start of a string

• To reverse the characters in a string

• To add characters to the start of a string

• To remove characters from the end of a string

In the email example, what does the right function do?

• Displays the first 9 characters of the email

• Displays the last 9 characters of the email

• Removes the last 9 characters of the email

• Removes the first 9 characters of the email

Which function is used to find the position of a space in a string?

• Len

• Right

• InStr

• Left

How do you calculate the number of characters to extract for the last name in the advanced example?

• By adding the lengths of the full name and first name

• By subtracting the length of the first name from the full name

• By dividing the length of the full name by the first name

• By multiplying the lengths of the full name and first name

What does the Len function do in string manipulation?

• It removes spaces from the string

• It converts the string to uppercase

• It reverses the string

• It calculates the length of a string

What is the result of concatenating the last name and first name with a comma in between?

• First name, Last name

• Last name First name

• Last name, First name

• First name Last name

Which symbol is used for concatenation in VBA?

• %

• #

• +

• &