VBA 字符串空间：首选方法

使用VBA编程语言时，字符串处理是非常常见的操作之一。在VBA中，我们可以使用多种方法来处理字符串，以满足不同的需求。在本文中，我们将介绍一些常用的方法和技巧，帮助您在VBA中更好地处理字符串。

vba
Dim str1 As String
Dim str2 As String
Dim result As String
str1 = "Hello"
str2 = "World"
result = str1 & str2
MsgBox result

vba
Dim str As String
Dim arr() As String
str = "1,2,3,4,5"
arr = Split(str, ",")
For i = 0 To UBound(arr)
    MsgBox arr(i)
Next i

vba
Dim str As String
str = "I like apple"
str = Replace(str, "apple", "banana")
MsgBox str

vba
Dim str As String
Dim datePart As String
str = "2022-01-01 12:00:00"
datePart = Mid(str, 1, 10)
MsgBox datePart

vba
Dim num As Integer
Dim str As String
num = 123
str = CStr(num)
MsgBox str