Is there a way to extract the last word from a string using a calculated field in SharePoint 2016?

1 Answer 1


You could try the below formula to achieve this:

=RIGHT([Text],LEN([Text])-FIND(" ",[Text],FIND(" ",[Text])+1))


enter image description here

  • SharePoint formulas are tricky! Problem will be when the text have less than or more than 3 words in it OR if there are more than one space after first word in the text (data errors). Commented Mar 14 at 13:20

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.