Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
taking a .txt email list that are separated with spaces and sort them in to excel cells
taking a .txt email list that are separated with spaces and sort them
in to excel cells Thank so much |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort data separated by commas | Excel Worksheet Functions | |||
how to generate email list for Outlook from Excel cells | Excel Discussion (Misc queries) | |||
how do I create email list from individual emails in Excel cells? | Excel Discussion (Misc queries) | |||
how to taking a .txt email list that are separated with spaces and sort them in to excel cells | Excel Worksheet Functions | |||
sort cells with spaces to the top | Excel Programming |