Results 1 to 4 of 4

Macro to fix zipcodes

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-29-2008
    Location
    usa
    MS-Off Ver
    EXCEL 2010
    Posts
    116

    Macro to fix zipcodes

    I have a spreadsheet and I have to fix zip codes everyday for the map to read them
    Example if zip code is 66606-5648 map will read the zip code,
    but if its 66606 it will not read it
    I need to macro that It will fix the zip code form 66606 to 66606-5648 the zip code doesn’t have to have the correct last four digits just any last four digit I attach a sample of the file
    Any help will be greatly apreciate
    Attached Files Attached Files
    Last edited by martinez_pedro; 03-31-2009 at 01:43 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1