Vba string

Dim text1 As String
text1 = "Hello"
text1 = text1 & " World"
Debug.Print Left(text1, 3) 			' Hel
Debug.Print Right(text1, 4) 		' orld
Debug.Print Mid(text1, 2, 3)		' ell
Debug.Print Len(text1)				' 11	(size)
Debug.Print Instr(text1, "World")	' 6    	(position in text1)

Similar codes

1 vote202 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote199 views1 answer
Type excel.application is not defined vb
VBA
0 vote257 views1 answer
Winforms dark title bar
VBA
0 vote210 views1 answer
Excel vba calculate
VBA
0 vote226 views1 answer
Find database connection string vb
VBA
0 vote233 views1 answer
Build an index all files of a FTP site
VBA
5 votes153 views1 answer
Vlookup vba
VBA
0 vote204 views1 answer
Vbnet hex to binary
VBA
8 votes293 views1 answer
Vba make integer
VBA
0 vote224 views1 answer
Excel vba first working day month
VBA