Table of contents
TOC
Collapse the table of content
Expand the table of content

Text.Range

Owen Duncan|Last Updated: 4/19/2018

About

Returns the substring from the text text found at the offset offset. An optional parameter, count, can be included to specify how many characters to return. Throws an error if there aren't enough characters.

Text.Range(text as nullable text, offset as number, optional count as nullable number) as nullable text  

Arguments

ArgumentDescription
textThe text to parse.
offsetThe index to start parsing at.
countThe number of characters to return.

Example 1

Find the substring from the text "Hello World" starting at index 6.

Text.Range("Hello World", 6) equals "World"  

Example 2

Find the substring from the text "Hello World Hello" starting at index 6 spanning 5 characters.

Text.Range("Hello World Hello", 6, 5) equals "World"  
© 2018 Microsoft