Skip to main content
Solved

Formula to pull a first name

  • May 10, 2023
  • 2 replies
  • 84 views

Forum|alt.badge.img+4

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.  

Best answer by MelloJello

IF(Name,TRIM(LEFT(TRIM(Name),FIND(' ',TRIM(Name)))))

2 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • 7 replies
  • Answer
  • May 10, 2023
IF(Name,TRIM(LEFT(TRIM(Name),FIND(' ',TRIM(Name)))))

Forum|alt.badge.img+4
  • Author
  • Known Participant
  • 12 replies
  • May 11, 2023
IF(Name,TRIM(LEFT(TRIM(Name),FIND(' ',TRIM(Name)))))

You are a legend. Thank you! Works perfectly.