Left characters

• Snippet
• Text
• 2 blanks to fill

=LEFT(Cell, N)

About this template

First N characters.

Category

Spreadsheet formulas

Pack

Text

Type

Snippet, a short message

Asks for

Cell, N

Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.

=LEFT({{Cell}}, {{N}})

More spreadsheet formulas templates

• Text before a character Snippet Split on a delimiter.
• Text after a character Snippet After the delimiter.
• Split into columns Snippet TEXTSPLIT.
• Replace text Snippet SUBSTITUTE.
• Contains text Snippet Search in text.
• First name from full name Snippet Before the space.

See all 75 spreadsheet formulas templates