Parses the specified text string and places the result in the specified range.
expression.ParseText(Text, Delimiters, ConsecutiveDelimAsOne, TextQualifier)
expression An expression that returns a Range object.
Text Required String. Specifies the string to be parsed.
Delimiters Optional String. Specifies the field delimiters.
ConsecutiveDelimAsOne Optional Boolean. True to have consecutive delimiters considered as one delimiter. The default value is False.
TextQualifier Optional String. Specifies the text qualifier. The default value is the double quotation mark character.
Example
This example parses the specified string into the range starting at cell A1.
Spreadsheet1.ActiveSheet.Range("A1").ParseText "name, address, city, state", ","