T in Google Sheets: Keep Text from Mixed Values
Understand text passthrough, empty-string results and propagated errors with a mixed-input worksheet.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
What T is useful for
Suppose an imported remarks column contains both descriptive labels and numeric flags. A helper column using T can retain the text while producing an empty string for the numeric values. Keep the original column: a disappearing value may still contain business information.
Syntax and result types
=T(value)
The argument may be a value or cell reference. Text is returned unchanged. An error remains the same error. Other values produce an empty string. Google describes T mainly as a compatibility function because Sheets already handles many conversions automatically. Google’s T reference supplies these rules.
Build a mixed-input example
Enter the following formulas in column A to establish each input type explicitly. Enter =T(A2) in B2 and copy through B6.
| Cell | Formula entered in A | Expected B result |
|---|---|---|
| A2 | ="Awaiting label" |
Awaiting label |
| A3 | =73 |
empty string |
| A4 | ="0073" |
0073 |
| A5 | =FALSE |
empty string |
| A6 | ="#N/A" |
#N/A as text |
For a separate error-propagation check, if A7 already contains an actual #N/A error, =T(A7) has expected result #N/A as an error. Merely typing the characters #N/A as text does not create that test.
These are independently checked type-rule expectations, not native Google Sheets observations. A3 and A4 are intentionally different: the number 73 and the text 0073 are different inputs even when both are used as identifiers.
Why a blank-looking result needs care
B3 still contains a formula. Its empty-string result should not be described as a physically empty cell. If another formula, export or filter depends on emptiness, test that downstream operation separately. T alone does not establish how every other operation will treat its result.
For a review workflow, keep A and B side by side, identify which original values disappeared, and decide whether each omission is desirable. Do not replace a mixed column with the helper results until those numeric values have been accounted for.
Troubleshooting
- A number disappears: this is the documented non-text branch, not number-to-text formatting.
- A numeric-looking code survives: check whether the input is stored as text, as A4 is.
- An error survives: T is not an error handler. Inspect the source formula and decide how that error should be handled.
- Leading zeros matter: establish the intended input type before cleanup; T does not reconstruct information already lost upstream.
Versions and related guides
This guide uses a cached Google help snapshot retrieved on 19 October 2026, with a reported crawl age of six days; it does not claim a minimum release or prove compatibility with every spreadsheet product. Native tests and screenshots remain pending.
See TEXT for formatted numeric text and N for Google’s numeric counterpart. Choose the operation from the desired output type rather than from the function name alone.