Most of the time, we will use the If Statement to test if the string starts with the specified string. “String” Like “SubString*” Example of Like We will use Like along with an asterisk (*) to test if the string begins with our substring. In this How To, I will show introduce the Like comparison operator, InStr, and Left built-in function. For example, we want to know how many customers have first name start with letter “P”. Some time we want to perform the action only on certain field or records that begin or start with the specified letter. There are many ways that we can test if the string which begin or start with the certain string or letter. VBA: How to Test if a String starts with certain letters
0 Comments
Leave a Reply. |