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
>
|