Extract the last word from a string

Question

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

Xyza_MSFT · Accepted Answer · 2024-03-14 03:08:06Z

1

You could try the below formula to achieve this:

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

Output:

answered Mar 14 at 3:08

Xyza_MSFT

5353 silver badges5 bronze badges

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).
– Ganesh Sanap - MVP
Commented Mar 14 at 13:20

Add a comment |

1 Answer 1