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

1 vote372 views1 answer
Vba optional
VBA
1 vote364 views1 answer
Excel vba first row in range
VBA
0 vote358 views1 answer
Vba range clear formatting
VBA
4 votes353 views1 answer
Excel vba determine number of elements in an array
VBA
8 votes406 views1 answer
Vba make integer
VBA
0 vote368 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
4 votes348 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote366 views1 answer
How to mount floppy disks in vb.net
VBA
3 votes383 views2 answers
Vba active workbook path
VBA
5 votes345 views1 answer
Excel vba high word from Long Integer
VBA