LEFT, RIGHT, MID

Modified on Wed, 1 May at 11:05 AM

Introduction

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


FORMULALEFT(text, num_characters)
EXAMPLE FORMULALEFT(text_col, 4)
EXAMPLE INPUTGigasheet Rocks
EXAMPLE OUTPUTGiga


Sample Usage


Valid ExamplesInvalid Examples
LEFT(Text Column,5)RIGHT(Text Column, "5")
LEFT("TEXTEREGEGEE",5)Right(Number Column, "3")
LEFT(Number Column,1)
LEFT(Date,5)
LEFT(Number as Text Data Type,2)


Notes

  • Quotes are optional with LEFT, RIGHT, & MID formulas


See Also

LENGTH


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