Ah, I see, I was supposed to use REPLACE with FIND. Thank you so much!
This is perfect!

swatsp0p Wrote:
Try this:

=REPLACE(A1,FIND(" ",A1,1),1,": ")

Does this work for you?


--
marlea
------------------------------------------------------------------------
marlea's Profile: http://www.excelforum.com/member.php...o&userid=26209
View this thread: http://www.excelforum.com/showthread...hreadid=473524