Convert Report number to Date and Time

[UKNOWINVU2]

I am trying to convert this report number to a date and time, is there a single formula that can achieve this or do I need extract the numbers using left/right formula?

W3_20190903_230338 = Sept.3,2019, 11:03:38 pm

 

[Fluff]

How about, with your value in A7
=DATE(MID(A7,4,4),MID(A7,8,2),MID(A7,10,2))+TIME(MID(A7,13,2),MID(A7,15,2),MID(A7,17,2))

 

[UKNOWINVU2]

That is amazing, thank you! Now I will try and figure out how to format cell to read "Sept.3,2019, 11:03:38 pm".

 

[Fluff]

You're welcome & thanks for the feedback