Excel VBA - Split text using " delimiter-CodePudding

I have a string of text on witch I need to split it using the symbol " as a delimiter. The problem I'm facing is than the "Split" function does not accept " as a delimiter by itself.

Any ideas on how to do so?

CodePudding user response：

Suppose you have Hello"Excel in cell A1 then try below sub.

Sub MySplit()
Dim x As String

    x = Range("A1")
    MsgBox Split(x, Chr(34))(1)

End Sub

CodePudding user response：

What you say is just not true.

A = "Cat*Dog"
B = Split(A, """")
For each thingy in B
    Msgbox thingy
Next