Pick out text from middle of a string

[aaron.phelan12345]

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

[JohnTopley]

Try

=MID(A2,SEARCH(">On",A2,1)+4,19)

[sweep]

Hi,

Does this work for you?

=MID(A2,3+FIND(">On ",A2),20)

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[aaron.phelan12345]

Sorry guys all of these is pulling the date time at the start rather than the one on the far right.

[TMS]

Edit: didn't look properly ...

Please Login or Register  to view this content.

[AB33]

A UDF alternative,
=Finddate(A2) where A2 is your range(cells) and drag it down as you do with any formula.