New Posts For Thread: excel email sort problem any help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23524618/excel-email-sort-problem-any-help-pleasehi guys I run a small club with about 6000 members I do newsletters for them once a fortnight with all our upcoming events etc. I have a excel file with all the email addresses in, is there a way of sorting them by email address so all the aol. **copy the email addresses so you have a 2nd copy in column b. == straight forward enoughThen use Text To Columns to split everything after the @ to a new column. == hightlight the column, go DATA / TEXT TO COLUMNS, choose delimited, put a @ in other ahttps://community.betfair.com/general_betting/go/thread/view/94082/23524618/excel-email-sort-problem-any-help-please?post_id=420408610#420408610copy the email addresses so you have a 2nd copy in column b. == straight forward enoughThen use Text To Columns to split everything after the @ to a new column. == hightlight the column, go DATA / TEXT TO COLUMNS, choose delimited, put a @ in other aMon, 22 Feb 2010 16:10:24 -0600sorry morrigan I did say thanks in advance but I have only just read the reply, could you please tell me in more detail, I am a bit useless with excel.it is 2007 by the wayhttps://community.betfair.com/general_betting/go/thread/view/94082/23524618/excel-email-sort-problem-any-help-please?post_id=420408586#420408586sorry morrigan I did say thanks in advance but I have only just read the reply, could you please tell me in more detail, I am a bit useless with excel.it is 2007 by the wayMon, 22 Feb 2010 12:57:32 -0600You are welcome, no worries.dont mention it.https://community.betfair.com/general_betting/go/thread/view/94082/23524618/excel-email-sort-problem-any-help-please?post_id=420408478#420408478You are welcome, no worries.dont mention it.Mon, 22 Feb 2010 00:59:28 -0600copy the email addresses so you have a 2nd copy in column b. Then use Text To Columns to split everything after the @ to a new column. Then you can sort by this column in ascending order.https://community.betfair.com/general_betting/go/thread/view/94082/23524618/excel-email-sort-problem-any-help-please?post_id=420408438#420408438copy the email addresses so you have a 2nd copy in column b. Then use Text To Columns to split everything after the @ to a new column. Then you can sort by this column in ascending order.Sun, 21 Feb 2010 07:41:07 -0600hi guys I run a small club with about 6000 members I do newsletters for them once a fortnight with all our upcoming events etc. I have a excel file with all the email addresses in, is there a way of sorting them by email address so all the aol. **https://community.betfair.com/general_betting/go/thread/view/94082/23524618/excel-email-sort-problem-any-help-please?post_id=420408434#420408434hi guys I run a small club with about 6000 members I do newsletters for them once a fortnight with all our upcoming events etc. I have a excel file with all the email addresses in, is there a way of sorting them by email address so all the aol. **Sun, 21 Feb 2010 07:31:52 -0600