Extracting the Last Word

[#1]

Hi - If I want to extract the last word in the Name column below, what would be the best way to so?

[#2 · Accepted solution]

Right click on the column header you wish to get the value from and create new formula column with Last Word

then you can take a look at the formula if needed

You can also do the extraction with Recode for example

[#3]

Thank you!

[#4 · Accepted solution]

The Word() function is perfect for this. Use "-1" to get the last word.

If you learn only one Formula Editor function, Word() is the one