Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Formula to pull a first name

Topic Labels: Formulas
Solved
Jump to Solution
1437 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kate_Jacobs
5 - Automation Enthusiast
5 - Automation Enthusiast

I don't know if this is possible, but it will save a lot of time if it is. I have a donor database where each donor is known by their full name, ie. "Kate Jacobs". Is there any way that I can add a column with some sort of formula that could just pull the first word from that record? For the purpose of mail merge - I want to be able to do a FName tag, but currently will have to manually go through and rename all the contacts.  

1 Solution

Accepted Solutions
MelloJello
5 - Automation Enthusiast
5 - Automation Enthusiast
IF(Name,TRIM(LEFT(TRIM(Name),FIND(' ',TRIM(Name)))))

See Solution in Thread

2 Replies 2
MelloJello
5 - Automation Enthusiast
5 - Automation Enthusiast
IF(Name,TRIM(LEFT(TRIM(Name),FIND(' ',TRIM(Name)))))
Kate_Jacobs
5 - Automation Enthusiast
5 - Automation Enthusiast

You are a legend. Thank you! Works perfectly.