Returns a text string representing a value formatted as a string. May employ concise or strict formatting rules.
Arguments
Name
Type
Description
value
any
A constant, reference or nested expression that provides the value that is to be represented as a text string.
[format]
logical
An optional constant, reference or nested expression that provides a logical flag that indicates if strict formatting is to apply. Defaults to FALSE if omitted.
Concise
the values appears as a simple text string representation.
1
Strict
text strings are included in quotation marks
Return Values
Type
Specific Value
Description
text string
The value, including any errors is presented as a text string representation of the value.
Notes / Comments / Advice / Warnings
Comment:
This function is useful in some more abstract and advanced calculations, where it is useful to convert all values to arrays of strings.. It can also be useful to convert the visible contents of cells that have been changed to data types to text for summarising.