Sign Up ›
  • BrandonPitts
  • NEWBIE
  • 10 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
20 replies

Help Splitting up Full Name field into First Name and Last Name

Hello

 

I have a field where a Full Name is entered - I need to split this into a First Name field and a Last Name field

 

I have created the fields - I need help on the formula

 

In many cases there are 4 entries

John abott-gacey

Mary Smith-Felch

Sam M. Wall

 

Thanks