Assuming your value is in A2, but this in B2:

=DATE(LEFT(A2,4),MID(A2,5,2),MID(A2,7,2))
+VALUE(MID(A2,9,2)&":"&MID(A2,11,2)&":"&RIGHT(A2,2 ))

Format the cell as Custom -- yyyy-mm-dd hh:mm:ss, then copy the
formula down.

Hope this helps.

On Jul 25, 11:02 am, Blue Fish wrote:
Hello:

I have import a text file that the Raw Data is "20070722130054". How
can I make the excel to recognize as "2007-07-22 13:00:54"?

Thanks!