You could use this formula in an adjacent cell and copy it down the
column, then copy the results and paste special values over the
original data (if you want to replace the data ONLY) then remove the
calculated column.
=IF(LEN(A1)5,MID(A1,1,5) & "-" & MID(A1,6,50),A1)
--
Excelenator
------------------------------------------------------------------------
Excelenator's Profile:
http://www.excelforum.com/member.php...o&userid=36768
View this thread:
http://www.excelforum.com/showthread...hreadid=573110