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

Webflow

View the structural outline of a webpage with the HTML outliner

view tutorial

Webflow

Automatically update copyright year on your website

view tutorial

Airtable

Airtable Tip - Structuring your Base with Helper Fields

view tutorial

Formstack

15 documents you can automate without code

view tutorial

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

❌
oops, something went wrong. please try again.