Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
E-mail Sort
Is it possible to sort by e-mail address? For example, I have a
spreadsheet with name and e-mail and I want to sort by e-mail address, but not by the begining of the address. Half are @yahoo.com, and the other half are @gmail.com. I want to sort out all those that are @gmail.com |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
E-mail Sort
One way is with a helper column. With your email addresses in column
A, put this in B1 and drag down =MID(A1,FIND("@",A1)+1,999) Select columns A and B and sort by column B. You can then delete or hide the helper column. Mike On Jan 22, 2:19*pm, tonyalt3 wrote: Is it possible to sort by e-mail address? *For example, I have a spreadsheet with name and e-mail and I want to sort by e-mail address, but not by the begining of the address. *Half are @yahoo.com, and the other half are @gmail.com. *I want to sort out all those that are @gmail.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
E-mail Sort
You could use Autofilter with the custom criterion "contains" gmail.com or
"ends with" gmail.com Alternatively you could use a helper column =RIGHT(A2,LEN(A2)-FIND("@",A2)) -- David Biddulph "tonyalt3" wrote in message ... Is it possible to sort by e-mail address? For example, I have a spreadsheet with name and e-mail and I want to sort by e-mail address, but not by the begining of the address. Half are @yahoo.com, and the other half are @gmail.com. I want to sort out all those that are @gmail.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I sort e-mail addresses? | Excel Discussion (Misc queries) | |||
How do I sort e-mail addresses without losing the links? | Excel Discussion (Misc queries) | |||
Sort column of e-mail addresses | Excel Discussion (Misc queries) | |||
sort e-mail address | Excel Discussion (Misc queries) | |||
sort a column of e-mail addresses by domain | Excel Discussion (Misc queries) |