Split String into Array using VBA (Visual Basic for Applications) code

Split String into Array using VBA (Visual Basic for Applications) code

Code:

Function SplitString(ByVal value As String)
    value = StrConv(value, vbUnicode)
    SplitString = Split(Left(value, Len(value) - 1), vbNullChar)
End Function

Above code will return an array of characters.

Leave a Reply

Your email address will not be published.