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

8 votes204 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote147 views1 answer
Vba random number
VBA
1 vote113 views1 answer
Vba compile error object required
VBA
1 vote109 views2 answers
Vba remove first 2 characters from string
VBA
0 vote148 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote135 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
5 votes149 views1 answer
Excel vba last byte from INTEGER
VBA
0 vote128 views1 answer
Vba sort the data Z to A
VBA
0 vote123 views1 answer
Excel vba protect sheet
VBA
2 votes128 views1 answer
Excel vba date to string conversion
VBA