Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ParseText Method

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

 

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.