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

5 votes146 views1 answer
Excel vba low byte from INTEGER
VBA
1 vote120 views1 answer
Excel vba to lower case
VBA
3 votes128 views1 answer
Vba folderexists
VBA
3 votes140 views1 answer
Vba continue for each loop
VBA
-1 vote134 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote85 views1 answer
Vba set vs dim
VBA
0 vote136 views1 answer
Vba remove last vbcrlf
VBA
0 vote129 views1 answer
Excel named range sum
VBA
0 vote137 views1 answer
Excel delete ever other vba
VBA
0 vote135 views1 answer
Programmatically copy data from one workshet to another excel
VBA