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?

dn610_0-1675866809271.png

[#2 · Accepted solution]

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

jthi_0-1675869156864.png

then you can take a look at the formula if needed

jthi_1-1675869179232.png

You can also do the extraction with Recode for example

jthi_2-1675869228422.png

[#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