• Unzip the .txt file from the .zip file
    • Open a blank excel document
     
    • Go to File > Open
     
    • Browse to the location of the .txt file
     
    • Choose to show Text files in the browse window and choose the AddressFinder return file
     
    • On the Text Import Wizard choose Delimited on Step 1 and then click Next
     
    • On Step 2 choose Comma as the separator and click Next
     
    • On Step 3 Choose Text as the data type for each Column
     
    • Click Finish






    To View the Moved Records:
       
      • After the file is opened in Excel go to Data > Sort
       
      • Choose to expand the selection
       
      • Sort by the DLVCode column
       
      • Each record that matched a National Change of Address Card will have a DLVCode. Refer to BB59552 for the footnote translations.