Split into columns

• Snippet
• Text
• 2 blanks to fill

=TEXTSPLIT(Cell, "Delimiter")

About this template

TEXTSPLIT.

Category

Spreadsheet formulas

Pack

Text

Type

Snippet, a short message

Asks for

Cell, Delimiter

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.

=TEXTSPLIT({{Cell}}, "{{Delimiter}}")

More spreadsheet formulas templates

• Replace text Snippet SUBSTITUTE.
• Contains text Snippet Search in text.
• First name from full name Snippet Before the space.
• Email domain Snippet After the @.
• Format number as text Snippet Currency text.
• Character count Snippet LEN.

See all 75 spreadsheet formulas templates