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

3 votes417 views1 answer
Extract word in a text in excel
VBA
0 vote345 views1 answer
Refresh token em vb net
VBA
0 vote396 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote350 views1 answer
Excel vba automatic calculation
VBA
31 votes496 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote367 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote377 views1 answer
Excel vba ternary
VBA
0 vote397 views1 answer
Find if year is leap year vb
VBA
0 vote378 views1 answer
Average vba
VBA
5 votes398 views1 answer
Excel vba get user selected range
VBA