TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.

How to get the last word from a sentence.

No need for complex Excel formulae, just use the "Extract Step" method in TaskPipes.

Select the appropriate column, then set the parameters to the last occurence of a space character (note the space in the image below) and the end.