Hi,

Am Tue, 18 Feb 2014 16:59:27 +0000 schrieb muskrat1977:

I have imported text that has the following format:
20 May 2014 1715

your text in A1. Then in B1:
=LEFT(A1,LEN(A1)-5)+TIME(MID(A1,LEN(A1)-3,2),RIGHT(A1,2),)
and format the cell DD MMM YYYY hh:mm



Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2