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 |
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 |
All times are GMT +1. The time now is 10:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com