 |
 |
Hi Brian, Thank you!! It was a really good method:-) I think a lot of people will also be happy with the new knowledge! Take care, Tannaze Postgraduate research student Email: [log in to unmask] Office Telephone: +44 (0)23 8059 5078 School of Psychology University of Southampton Highfield Campus SO17 IBJ United Kingdom Tel: +44 (023) 8059 3995 Quoting [log in to unmask]: > Hi Tannaze, > > This is the only way I can think of (assuming your original list is in > column A): > > Select col A > Copy > Open Word and Paste Special as unformatted text > Select all text > Go to Table, Convert text to table... > Separate text at.. Other: > Enter @ in the Other box > This should separate your text into 2 columns: the text before and after > the @ sign > Copy the two columns > Paste into Excel columns B & C (ensuring the rows are lined up correctly) > > You should now have your original email addresses in col A, with the host > name separated into column C that you can use for the standard > alphabetical sorting. > > Hope that helps, > > Brian Saxby > Institute for Ageing and Health > Newcastle University > > > > > > Hello all, > > > > Hope everyone is well:-) > > > > Just wondering if anyone could work out an Excel problem for me... > > > > I have a column with a large list of email addresses, (for example > > [log in to unmask], [log in to unmask]). What i want to do is sort them by > the > > email address, ie get all the hotmail ones together, all the gmail ones > > together and so on. But obviously, i can't use standard sort function > as > > this would just sort them alphabetically from the 1st letter. (In > effect, > > they are gonna be sorted from within the middle of the cell!). Other > than > > have 2 columns (name, email host), is there any way to do this?? > > > > Thanks for your help in advance! > > > > Take care, > > > > Tannaze > > > > > > > > Postgraduate research student > > Email: [log in to unmask] > > Office Telephone: +44 (0)23 8059 5078 > > > > School of Psychology > > University of Southampton > > Highfield Campus > > SO17 IBJ > > United Kingdom > > > > Tel: +44 (023) 8059 3995 > > > > > > >