Sorting Zip Codes with Hyphenated Extensions

MORE INFORMATION

To place the extensions in a separate field in Works for Windows version 3.0, do the following:

1. Insert a new database field or spreadsheet column for the extensions to the immediate right of the zip code field.
2. Select the zip code column or field.
3. From the Edit menu, choose Copy.
4. From the File menu, choose Create New File and select Word Processor.
5. In the Word Processor document, select Paste from the Edit menu. This will insert all of your zip codes.
6. From the Edit menu, choose Replace.
7. In the Find What box, type -.
8. In the Replace With box, type ^t. The ^t is a special character for the tab mark.
9. Choose Replace All.
10. When this task has been completed, choose Select All.
11. From the Edit menu, choose Copy.
12. In the Spreadsheet or Database document, put the cursor in the first zip code cell.
13. From the Edit menu, choose Paste.

Now the new field will contain the extension

In Works for Windows version 2.x, do the following:

1. Insert a new database field or spreadsheet column for the extensions to the immediate right of the zip code field.
2. Select the zip code column or field.
3. From the Edit menu, choose Copy.
4. From the File menu, choose Create New File and select Word Processor.
5. In the Word Processor document, choose Paste from the Edit menu. This will insert all of your zip codes.
6. From the Select menu, choose Replace.
7. In the Find What box, type -.
8. In the Replace With box, type ^t. The ^t is a special character for the tab mark.
9. Choose Replace All.
10. When this task has been completed, choose Select All.
11. From the Edit menu, choose Copy.
12. In the Spreadsheet or Database document, put the cursor in the first zip code cell.
13. From the Edit menu, choose Paste.

The first five-digits of the zip codes will now be in the original zip code field or column and the extensions will be in the new field or column to the right. You can now sort and the first five-digits of the zip code will all be together.