Can you use another column with a formula like:

=left(a1,5) & "-" & right(a1,4)

Number formats work with numbers--not text.

Phillip wrote:

I have zip codes plus carrier routes stored together as one
string. I want a dash between the zip code and route,

95006RR24 should display as 95006-RR24

this would be easy if it where all digits like zip+4. nothing
i've tried works. any suggestions?

Phil

--

Dave Peterson