Hello,

So I have many lines of text all totally different lengths and I want to pull out the last date and time (highlighted in red on document)Date Time Forumla Help.xlsx

The way I assume it can be done is by looking in from RIGHT to find ">on " and then taking the next 19 char. But that is a lot easier said than done!!
(the lines of code are actually way longer than that, I shortened for the purpose of this post going from the left isn't an option)

If anyone knows the code for this that would be greatly appreciated!

Kind Regards
Aaron