Hi Phil,

To import your .txt file as rows instead of columns in Excel, you can follow these steps:

1. Open a new Excel workbook and click on the "Data" tab in the ribbon.
2. Click on "From Text/CSV" in the "Get & Transform Data" section.
3. In the "Import Data" dialog box, locate and select your .txt file, then click "Import".
4. In the "Text Import Wizard - Step 1 of 3" dialog box, select "Delimited" and click "Next".
5. In the "Text Import Wizard - Step 2 of 3" dialog box, select "Semicolon" as the delimiter and make sure the "Treat consecutive delimiters as one" checkbox is unchecked. You should see your data previewed in the "Data preview" section as a single column. Click "Next".
6. In the "Text Import Wizard - Step 3 of 3" dialog box, you can leave the default settings and click "Finish".
7. In the "Import Data" dialog box, choose where you want to import the data (e.g. a new worksheet) and click "OK".

Your data should now be imported into Excel as a single column with each email address in a separate row. You can then format the column as needed (e.g. remove the "[email]" tags) and save the file.