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 vote263 views1 answer
Vba set vs dim
VBA
0 vote330 views1 answer
Vba character ascii code
VBA
0 vote325 views1 answer
Excel vba disable screen update
VBA
4 votes309 views2 answers
Vba create folder if not exist
VBA
3 votes326 views1 answer
Vba make long from two words
VBA
0 vote334 views1 answer
Vba extract filename from path
VBA
0 vote308 views1 answer
Vba collection key list
VBA
1 vote303 views1 answer
Excel date to unix timestamp
VBA
0 vote302 views1 answer
Excel vba show developer tab
VBA
3 votes313 views1 answer
Extract the nth word from a text string
VBA