VALUETOTEXT(value [,format])

Returns the text from any specified value.

valueThe value to convert to text.
format(Optional) The format:
0 = concise
1 = strict

Remarks

* Only available in Microsoft 365 and has not been released to everyone yet.
* You can use Text to Columns to convert values to text.
* You can use the ARRAYTOTEXT function to return text from an array.
* You can use the CONCAT function to return a value as text.
* You can use the ISTEXT function to return True or False depending if the value is text.
* You can use the TEXT function to return a number as a formatted text string.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=VALUETOTEXT("some text") = some text


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top