LENGTH

Modified on Wed, 1 May at 11:17 AM

Introduction

Returns the minute component of a specific time, in numeric format.


FORMULA

LEN(text)

EXAMPLE FORMULALEN(text_col)
EXAMPLE INPUTGigasheet
EXAMPLE OUTPUT9


Sample Usage


Valid ExamplesInvalid 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 support@gigasheet.com

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article