All tips

Split full name into first & last

If you need to separate the first and last name from a full name in one row, you do it manually. For 10 rows, you also do it manually. But what happens when you need to do it for dozens, hundreds, or thousands of rows?

Well, you need formulas.

To separate first and last names:

  1. In your database, create two new formula properties ("First name" & "Last name").
  2. In the first name property, input the following formula: replaceAll(prop("Full name"), "(?<= ).+(?=)", "")
  3. In the last name property, input the following formula: substring(prop("Full name"), length(prop("First name")))

The First name formula will scan the Full name and get only the part before the first space. The Last name formula will "subtract" the First name from the Full name.

Master Notion, 5 minutes a week

Want to be in the loop with everything Notion? Join the 10,000+ Notioneers on the #1 Notion-focused newsletter.
Every Tuesday, I’ll hit you up with an email, giving you 3 tips on how to make the most of Notion, 2 (awesome) resources, and 1 Tweet of the Week.

Latest issues