The Ultimate Excel VBA Course - Learn and Master VBA Fast - String Exercise
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Hard
Wayground Content
FREE Resource
The video tutorial explains how to reformat a product code using Excel VBA. It starts by removing hyphens from the code using the Replace function. Then, it demonstrates how to insert a 'C' after 'PD' using the Left and Mid string functions, as VBA lacks a direct insert function. Finally, it combines the modified parts to produce the desired output, showcasing the use of concatenation in VBA.
Read more
1 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What new insight or understanding did you gain from this video?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
