Airtable

How to split first and last name in Airtable

In this quick tutorial, we'll show you how to split full names - into first and last - in Airtable, a game-changer for document automation.

👉 Step 1: Set Up Your First Name Formula.

LEFT(TRIM(Name), FIND(" ", TRIM(Name)))

‍

👉 Step 2: Grab the Last Names using Right()

RIGHT(TRIM(Name), LEN(TRIM(Name)) - FIND(" ", TRIM(Name)))

‍

This tip has so many practical applications... Imagine personalized letters, invoices, and certificates—all automated with the power of Airtable. We've done it, and now it's your turn! Check out www.nocodecollab.com/university

Level Up Your Skills: Explore Document Automation

Ready for the next step? Head over to www.nocodecollab.com and dive into our document automation course. Become a pro at transforming your workflows!

More tutorials

Formstack

Google Sheets

Mailchimp

Squarespace

Typeform

Tips for building complex no code workflows

view tutorial

Airtable

UTM Link Builder in Airtable

view tutorial

Airtable

4 Ways to Trigger Airtable Scripting Blocks for Workflow Efficiency

view tutorial

Zapier

Webflow

How to send yourself an SMS after a Webflow form submission

view tutorial

✅
Thanks – you're on the list and will receive our next newsletter.

❌
oops, something went wrong. please try again.