SHAPETEXT Function
Last modified: March 09, 2015
Applies to: Office 2013 | Visio 2013
In this article
Syntax
Remarks
Example 1
Example 2
Example 3
Gets the text from a shape.
SHAPETEXT (shapename!TheText[,flag])
Parameters
|
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
|
shapename!TheText |
Required |
|
A reference to the cell named TheText in the target shape. Shapename! is the name of the shape from which you want to retrieve the text. |
|
flag |
Optional |
Numeric |
A bit that specifies the format of the text. The default flag (0) shows the text exactly as it is shown in the shape. |
Return Value
String
You can use any combination of the following flags with the SHAPETEXT function.
|
Flag |
Description |
|---|---|
|
0 |
Show text exactly as shown in shape. |
|
1 |
Include discretionary hyphens. |
|
2 |
Don't include expanded text in fields. |
|
4 |
Convert tabs to a single space. |
|
8 |
Convert tabs to a set of spaces. |
|
16 |
Convert carriage returns and line feeds to spaces. |
|
32 |
Convert typographer quotes to regular quotes. |
|
64 |
Convert adjacent white space to a single space. |