Split First and Last Names

[Steven_Hambleto]

Hi all,

I want to use Zapier to export my table to Campaign Monitor but I only need the first name from my primary field which includes the person’s full name (first_name last_name).

Any ideas how I can accomplish this in the table or via Zapier?

I don’t mind creating a first name field and hiding it.

[Justin_Barrett]

Welcome to the community, Mark! To keep all parts except the last name, it’s only a slight variation of the formula that @W_Vann_Hall posted above to keep only the last name:

REPLACE({Name},FIND("~",SUBSTITUTE({Name}," ","~",LEN({Name}) - 
LEN(SUBSTITUTE({Name}," ","")))),LEN({Name},"")

[Mark_Haynes]

Thanks, Justin!!! You rock! :slightly_smiling_face:

[Cendecon_Crime_]

Is there a way to do this to extract just the street numbers from an address? like 1234 sesame St. Can I get just 1234

My column is called site address

[Elias_Gomez_Sai]

If the numbers are always at the beginning you can search for the space and extract the left part

[W_Vann_Hall]

I’ve done a bad job of updating earlier posts, but version 3 of my name processing routines can be found here.

And those dealing with patronymics and matronymics may want to check the formula and base referenced here.

[Lisa_H]

I am having a really hard time getting my Names column to split into First names, Last name

In the Names Column I would add the name in this format:

Danger, Bob & Lucy
Jitter, Bug

Then I need to write formula’s to get the names into their respective columns.

I used this Formula, to grab the Last name…

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

but after that, I can’t get it to work right!

Could someone plz help? Thank you!!!

(I tried some diff variations using RIGHT instead of LEFT… lol and that didn’t work either…)

[W_Vann_Hall]

You have the formula for {Last Name}; for {First Name} use

RIGHT(
    Name,
    LEN(
        Name
        )-FIND(
            ',',
            Name
            )-1
        )

P.S. I think I want to meet your friends! :winking_face:

[Lisa_H]

THANK YOU!!! That worked! :grinning_face_with_big_eyes:
I can never wrap my head around the LEN functions… doesn’t matter how many times I study it… My brain just seems to fuzz and thats it.

[Matthew_Pupa]

W_Vann_Hall:

LEFT(full_name, SEARCH(" ",full_name)-1)

I was playing around with this for my own purposes, and came up with this. If you have very clean first and last name, the function below can be used to get last name.

RIGHT(fullname, LEN(fullname)-SEARCH(" ", fullname))

[Justin_Barrett]

Here’s yet another way to pull a last name, assuming you’ve got a field extracting the first name, and that it’s only a two-part name:

SUBSTITUTE({Full Name}, {First Name} & " ", "")