- Export the file as text (*.txt).
- In Excel, select File, Open from the menu bar, and select the TXT file.
- The Excel Text Import Wizard is automatically activated. In step 1, select Fixed Width and click Next.
- In Step 2, follow the steps to create column breaks. Click Next.
- In step 3, highlight the column with the import ID (or data formatting as date), and select Text. Click Finish.
Connect and collaborate with fellow Blackbaud users.