I'm trying to write a calculated column formula to return the First Name from a Full Name column. The issue is, that the full names are displayed in different formats:

Jacob J. Smith
Peter Grabowski
Anna Maria Gonzales
  • 1
    What are the expected results for above name examples? "Jacob J.", "Peter", "Anna Maria" or "Jacob", "Peter", "Anna"? Mar 7, 2023 at 13:50

1 Answer 1


If this is what you are looking for :

enter image description here

Then here is the formula that you need to use inside your Calucalted column :

=LEFT(Title,FIND(" ",Title)-1)

Replace Title with your FullName column Static name

  • You're a STAR :* Thank you.
    – Alex
    Mar 8, 2023 at 7:56
  • Great to hear that it helped, thank you for marking my answer as a solution. Let me know if you need anything else Mar 8, 2023 at 15:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.