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

0 vote144 views2 answers
Excel vba number format file size
VBA
0 vote139 views1 answer
Excel vba extract year
VBA
31 votes260 views1 answer
Vba how to convert a column number into an Excel column
VBA
8 votes219 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote148 views1 answer
Excel last used row
VBA
3 votes152 views1 answer
Vba double quote
VBA
0 vote134 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote125 views1 answer
Style percent not found vba
VBA
-1 vote130 views1 answer
Vba sendkeys
VBA
3 votes144 views1 answer
Excel insert blank row for value change in column
VBA