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

Formstack 101: Using PowerPoint for documents

view tutorial

Webflow

Improving your forms with input masks

view tutorial

Formstack

Workflows Part 1: Using Formstack to streamline your team

view tutorial

Airtable

Use Airtable scripts to resize and crop images

view tutorial

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

❌
oops, something went wrong. please try again.