Try this:

For A1 containing text in the format you described
A1: Transfer Date: 3/19/2006

B1: =--TRIM(MID(A1,FIND(":",A1)+1,255))
Format B1 as a date.

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=518715