So I have a column of zip codes - some with 5 numbers and some with 9.
What I am trying to do is create a formula where if there are more than
5 characters in that cell, insert a "-" after the 5th character from the
left...does anyone know how to do that?

what I am trying to do...
befo
503122540

after:
50312-2540

without going through each cell manually!

Thanks


--
rae820
------------------------------------------------------------------------
rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
View this thread: http://www.excelforum.com/showthread...hreadid=573110