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
|