
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2017 09:51 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 02, 2019 09:14 PM
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 as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 03, 2019 11:34 AM
Thanks, Justin!!! You rock! :slightly_smiling_face:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 24, 2019 03:17 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 24, 2019 03:21 PM
If the numbers are always at the beginning you can search for the space and extract the left part

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 27, 2019 09:47 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 02, 2019 09:24 AM
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…)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 02, 2019 05:11 PM
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:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 03, 2019 07:18 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 24, 2019 09:13 PM
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))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 25, 2019 06:49 PM
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} & " ", "")
