T(value)

Returns the text string of the value given.

valueThe value you want to test.

Remarks

* If "value" is text, then "value" is returned.
* If "value" is a number, "" (empty string) is returned.
* This function is provided for compatibility with other spreadsheet programs.
* This function is not used a lot as Microsoft Excel automatically converts values when necessary.
* For the Microsoft documentation refer to support.office.com

 A
1=T("sometext") = sometext
2=T("true") = true
3=T("20+100") = 20+100
4=T(100) = ""

1 - What is the text in the string "sometext".
2 - What is the text in the string "true".
3 - What is the text in the string "20+100".
4 - This is a numerical value so an empty string is returned.

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