That worked. Thanks!
--
Texas Wannano


"Peo Sjoblom" wrote:

One way

=LEFT(A2,FIND(" ",A2))+SUBSTITUTE(MID(A2,FIND(" ",A2)+1,255),"pm"," pm")

format custom as mm/dd/yy hh:mm AM/PM


--
Regards,

Peo Sjoblom



"Wannano" wrote in message
...
A2: 4/03 6:36pm
B2: FORMULA HERE

In B2, I need to convert A2 to 4/3/07 6:36 pm - putting a space between
the
time and PM.

Thanks!

--
Texas Wannano