ParseText Method Example
This example parses the specified string into the range starting at cell A1.
Spreadsheet1.Range("a1").ParseText "name, address, city, state", ","