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

4 votes196 views1 answer
Excel vba check cell not empty
VBA
0 vote225 views1 answer
Excel vba protect scenarios
VBA
1 vote202 views1 answer
Highlight selected cell in excel vba
VBA
0 vote190 views1 answer
Excel vba disable screen update
VBA
31 votes490 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote206 views1 answer
Windows Forms dark title bar
VBA
2 votes197 views1 answer
Excel vba date to string conversion
VBA
0 vote211 views4 answers
How to continue formula in below line in vba code
VBA
3 votes195 views1 answer
Vba folderexists
VBA
0 vote222 views1 answer
Tester si une case est vide vba
VBA