taking a .txt email list that are separated with spaces and sort them in to excel cells
(XL 2003)
-DataImport 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
- DataTextToColumns
- 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
-EditPasteSpecialTranspose
- Optionally, delete the original data
-Select the vertically laid out data
- DataSort
HTH,
wrote in message
ups.com...
taking a .txt email list that are separated with spaces and sort them
in to excel cells
Thank so much
|