Thanks very much everyone, much appreciated.
It is JSON and is provided to me on a weekly basis from another business.
As I have to do this each week, I was hoping for a formula to pull out the last word so I can drop the data in my template and generate the report I need without the need to...
Hi,
I'm trying to extract the final word in a string of text - This could be of a variable length but there are consistently special characters in front of the the word and after the word. I'm so close but can't quite get it right - Any help would be greatly appreciated.
Sample string...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.