Fatman Posted July 3, 2008 Share Posted July 3, 2008 I have some nine digit zip codes (with a dash between) and want to make them five digits - any ideas? Quote Link to comment Share on other sites More sharing options...
Codwagon Posted July 3, 2008 Share Posted July 3, 2008 In new column : =LEFT(cell location,5) with cell location example =LEFT(A1,5) copy down formula then copy and paste special as values. Delete old column. Quote Link to comment Share on other sites More sharing options...
Fatman Posted July 3, 2008 Author Share Posted July 3, 2008 In new column : =LEFT(cell location,5) with cell location example =LEFT(A1,5) copy down formula then copy and paste special as values. Delete old column. Brilliant - thank you sir! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.