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 vote126 views1 answer
Vba extract filename from path
VBA
1 vote111 views1 answer
Excel vba last row of range
VBA
0 vote119 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote157 views1 answer
Vbnet check if string is only letters
VBA
0 vote136 views1 answer
Vba parameter adodb null value
VBA
0 vote137 views1 answer
Vba character ascii code
VBA
0 vote119 views1 answer
Vb.net change cursor to wait
VBA
1 vote125 views2 answers
Get all column names from excel vba
VBA
0 vote123 views1 answer
Vbs expand env var
VBA
1 vote134 views1 answer
Vba login website
VBA