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

2 votes163 views2 answers
Constructor vb.net
VBA
4 votes192 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote181 views1 answer
Excel vba urlmon
VBA
0 vote216 views1 answer
Vba foreach 2d array
VBA
0 vote180 views1 answer
Vba compare strings
VBA
6 votes185 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote169 views1 answer
Vba len variant
VBA
0 vote184 views1 answer
Vba array dimensions
VBA
0 vote179 views1 answer
Vb streamreader
VBA
0 vote179 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA