Hi,
I use below code to split the text without any comma,
Sub RSplit()
For I = 2 To Cells(Rows.Count, 3).End(xlUp).Row
mysplit = Split(Cells(I, 3).Value & " #", " ", , vbTextCompare)
Cells(I, 3).Resize(1, UBound(mysplit)).Value = mysplit
Next I
End Sub
But if text have...