=IF(LEN(A1)=8,0&LEFT(A1,4),LEFT(A1,5))
-- Carlos
"Robert Judge" wrote in message
...
I have received an EXCEL 2003 worksheet with a column that contains many
zip
codes, improperly formatted. The cells contain, for instance:
10751746, but I want 01075
10271234, but I want 01027
10359999, but I want 01035
How can I convert the numbers above to give me the numbers I want as
indicated above? I will appreciate advice.
|