{"id":373,"date":"2013-02-28T12:42:47","date_gmt":"2013-02-28T12:42:47","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=373"},"modified":"2020-04-23T11:02:10","modified_gmt":"2020-04-23T11:02:10","slug":"excel-vba-lesson-8-string-functions","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-8-string-functions\/","title":{"rendered":"Excel VBA Lesson 8: String Manipulation Functions"},"content":{"rendered":"\n

<<Lesson 7>><\/a> [Contents] <\/a><<Lesson 9>><\/a><\/strong><\/h4>\n\n\n\n

Excel VBA can handle strings just as well as the stand-alone Visual Basic program. All the string handling functions in Visual Basic such as Len, Right, Left, Mid, Trim, Ltrim, Rtrim, Ucase, Lcase, Instr, Val, Str ,Chr and Asc can be used in Excel VBA.<\/p>\n\n\n\n

8.1 The InStr function<\/strong><\/h3>\n\n\n\n

InStr is a function that looks for and returns the position of a substring in a phrase<\/p>\n\n\n\n

Example 8.1<\/strong><\/h4>\n\n\n\n

Private Sub cmdInstr_Click()
Dim phrase As String
phrase = Cells(1, 1).Value
Cells(4, 1) = InStr(phrase, “ual”)
End Sub<\/p>\n\n\n\n

The function InStr(phrase,”ual”) will find the substring “ual” from the phrase “Visual Basic” entered in cells(1,1) and then return its position, in this case, it is 4 from the left.<\/p>\n\n\n\n