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 vote146 views1 answer
Vba change named range address
VBA
2 votes156 views1 answer
Excel vba date to string conversion
VBA
0 vote145 views1 answer
Vba createparameter null
VBA
0 vote158 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote165 views1 answer
Power query M substract minimum value of column -dax
VBA
4 votes155 views2 answers
Vba create folder if not exist
VBA
0 vote177 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote155 views1 answer
Group controls programmatically vb
VBA
0 vote150 views1 answer
Freeze panes vba
VBA
0 vote158 views1 answer
.net dark title bar
VBA