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 ... ... <看更多>

in a column, your data can not, so it's obviously easier in Excel. Multiple field calcs with the python string.split() function using the first ... ... <看更多>