Extract Date and time from the Text Column

[zorro]

Perfect, thanks for all your help !!!

[snb]

Or simply

=MID(A1;FIND(":";A1)-15;25) 

[jolivanes]

I don't know if you tried snb's formula but if you found that it does not work it is because you need to change the semicolon ( to a comma(,).
You might also take his counting with a grain of salt. 15 Should be 14 and 25 should be 23.
No offence snb. I know you want people to think for themselves.

[rollis13]

@jolivanes, have you tested with:

Tausif.Shaikh Aug 8, 2016, 11:12:50 PM
or
Tausif.Shaikh Aug 18, 2016, 3:12:50 PM

[jolivanes]

Indeed. I stand corrected.
I guess instead we could use Trim
My apologies snb.

[snb]

@joli

I don't accept, because you shouldn't have apologized in the first place. I always appreciate your contributions very much.

[jolivanes]

ok, thanks for the kind words and we'll leave it at that.
Keep on "duimen voor Max Verstappen"

[snb]

Now I don't anymore....
You remember the agreement of Paris to reduce....

[Admin]

Keep on "duimen voor Max Verstappen"

For Kimi

[jolivanes]

@Admin
Kimi is doing better in Singapore.
Could not fing anything for him though.