Inserting Characters
On Fri, 18 Aug 2006 11:56:49 -0400, Excelenator
wrote:
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)
Of course, if the zip code has a leading zero, as mine does, your formula does
not give useful results:
046670208
Your formula gives: 46670-208 when a more useful result would be 04667-0208
See my response for a different solution.
--ron
|