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 vote186 views1 answer
Excel vba unlock sheet without password
VBA
0 vote152 views1 answer
Vba border weight
VBA
1 vote145 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
1 vote156 views1 answer
Excel vba first and last row and column in range
VBA
0 vote151 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote152 views1 answer
Vbnet hex to binary
VBA
0 vote153 views1 answer
Vb net dgv doesn't keep currency format
VBA
8 votes281 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote153 views1 answer
Openfiledialog specific folder
VBA
1 vote159 views1 answer
Excel how to format bytes as KB, MB, GB
VBA