Introduction
Returns the minute component of a specific time, in numeric format.
| FORMULA | LEN(text) |
| EXAMPLE FORMULA | LEN(text_col) |
| EXAMPLE INPUT | Gigasheet |
| EXAMPLE OUTPUT | 9 |
Sample Usage
| Valid Examples | Invalid Examples |
| LENGTH(Text Column) | LENGTH("42") |
| LENGTH("Sheet Loader") | |
| LENGTH("42") | |
| LENGTH(Number Column) | |
| LENGTH(Date) | |
| LENGTH(Number as Text Data Type) | |
| CONCAT(Text Column,CONCAT(1,CONCAT(2,3,4))) |
Notes
- LEN can be used with quotes and without. For example “gigasheet” will return “9” in a new column.
See Also
Still having issues? Contact us at [email protected]
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article