Input strinG
“K aravinthan Male Pondicherry”
YourString.Split(" "c)
In case you have tabs, this thread might help as well: Split string on tab character
1 Like
try Split(String, vbTab)