Separating Contacts column into First and Last name

Platform discussions monday sales CRM
1

Hello,

We set up a Contacts board as part of the Basic CRMs feature. Is there a way to separate the contact column - someone’s full name - into a First and Last name column through an automation? Thank you!

2

Hi! As outlined in this post, you can separate them through two formula columns.

The first column should contain this formula:

LEFT({Name}, SEARCH(" ", {Name})-1)

And the second column should contain this one:

RIGHT({Name}, LEN({Name})- SEARCH(" ", {Name}))

3

Thank you! Is there a way to adjust the formula to capture middle names or first names with two names?

4

@JCorrell Hi ! I saw some other formulas you wrote on other threads, but none of those worked.

image
image841×159 13.3 KB

We need a last name - with only the last name, is there a way to do this? Currently in this snip: RIGHT({Name}, LEN({Name})- SEARCH(" ", {Name})) is the Claimant last name - but as you can see it shows everything to the right of the first name. I tried ones from this thread too and they did not work: First name, Last Name Split in first column. Would you be able to help?

5

@Rach12

Try this:

REGEXEXTRACT({Name},".*?(\w*)$")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like
6

Hi Jim, this works perfectly!! Thank you so much for your assistance! :+1:

7

Hi Jim, This is very helpful. How do I reverse this formula to capture the first name of the contact?

Thank you!!!

8

Hi Jim,
I figured it out!!

REGEXEXTRACT({Name},“.?(\w)?”)

Doug

1 Like
9

LOL same timing…Thank you! Only to find out I can’t use a formula in an automation :frowning:

All I’ve been trying to do is respond to customers inbound email “request for information” with their first name…, (I thought this formula would do it)

Doug