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 vote192 views1 answer
Vbscript Trim
VBA
25 votes343 views3 answers
String to date vb
VBA
0 vote185 views1 answer
Vba extract filename from path
VBA
0 vote185 views1 answer
Vba html document reference
VBA
0 vote168 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote181 views1 answer
Vba exit while
VBA
0 vote175 views1 answer
Freeze panes vba
VBA
0 vote177 views1 answer
Show unix time in vba
VBA
0 vote171 views1 answer
How to use if condition in time vba
VBA
0 vote170 views1 answer
Excel vba remove formatting from cell
VBA