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

18 votes590 views2 answers
Vba make word from bytes
VBA
0 vote242 views1 answer
Vba option button selected
VBA
0 vote245 views1 answer
Vba dropdown event
VBA
0 vote285 views1 answer
Excel vba protect content
VBA
0 vote230 views1 answer
Vba full date format
VBA
1 vote240 views1 answer
Add a index column power bi
VBA
0 vote240 views1 answer
Sort dictionary by key vba
VBA
0 vote313 views1 answer
Excel vba add reference programmatically
VBA
0 vote251 views1 answer
Vb.net change cursor to wait
VBA
0 vote294 views1 answer
Vba excel do not recalculate before save
VBA