(XL 2003)
-Data>Import External Data
The wizard will *probably* detect that your file is delimited, if so:
a) Select Delimited. Next.
b) Select Space (and unselect Tab, etc.). Finish
If the wizard didn't detect a delimted file, or if you want to do it
manually (open the text file in notepad, copy all, then paste into Excel):
- Select the data
- Data>TextToColumns
- Follow a) & b) above
That gets each email address into its own cell across the sheet (up to the
255 column limitation pre-XL2007).
If you have more than 255 addresses in the file (and aren't using XL2007)
you'll need to break the file into pieces.
To get the data into a sortable list:
-Select the horizontally laid out data
-Copy
-Select an empty cell where you want your list to begin
-Edit>PasteSpecial>Transpose
- Optionally, delete the original data
-Select the vertically laid out data
- Data>Sort
HTH,
