If value is or relates to text, T returns value. T returns “” if the value does not refer to text (empty text).
In most cases, you don’t need to utilize the T function in a calculation since Microsoft Excel automatically transforms data as needed. This function is offered for interoperability with other spreadsheet applications.