Formula to extract the last word in a multi-word string

[Daniel_Robbins]

I have a column that has strings such as “foo bar thud”, “alpha beta gamma omega” “John Mary”. I want to create another column that just displays the last “word” from each of these strings --> “thud”, “omega”, “Mary”

Any help is appreciated.

Thanks,

[Tuur]

Maybe you could nest a couple of SEARCH & REPLACE functions. Searching for the first space and replacing the string from the beginning up to that point with nothing. Combine with a dash of IF() perhaps.

Please note that you will need to nest at least as many times as there would be possible words in your string and the combined function will be a monster.

In other words, there is no proper solution that I’m aware of, but if you really want to do this and need more help let me know.

[Matt_Sayward]

I wish things like =RIGHT() weren’t restricted to character count. An ‘until’ definer would be really useful. Like, get all characters from the right of a string until a space is encountered.

[Tuur]

Something like searching the other way around (RSEARCH?) would be helpful indeed.

Or a more basic string reverse function would probably be even better…

[W_Vann_Hall]

You’ve probably found your answer by now – but if not, you may want to check this post.

Split First and Last Names

That's a little more difficult… At heart, the formula would be something like this: REPLACE({Name},1,FIND("~",SUBSTITUTE({Name}," ","~",LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")))),"") That's a little hard to suss out at first glance, so let me break it down, back to front: LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")) gets the difference in length between {Name} and {Name} with all spaces stripped. This gives us the index of the last space in the name, which presumably prefaces the las…