ParseText Method

Microsoft Office Web Components Visual Basic

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", ","