If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sort a column (specifically email data) by end of text, not beginn
One of my files contains a field of Emails. I want to sort it by the ISP, not
the beginning of the text. so if an email is , I want to sort it so I can view all the , etc. -- the only way I know how to sort is by Ascending/descending and it sorts by the beginning of the text. Thanks! |
#2
|
|||
|
|||
Sort a column (specifically email data) by end of text, not beginn
Create a 'helper column' in which you tease out the ISP. Ex: if the email
address is in A2, enter =RIGHT(A2,LEN(A2)-FIND("@",A2)) in B2 to calculate just the ISP. Autofill that formula to each row, then sort based on the new column. "Zip code help" wrote: One of my files contains a field of Emails. I want to sort it by the ISP, not the beginning of the text. so if an email is , I want to sort it so I can view all the , etc. -- the only way I know how to sort is by Ascending/descending and it sorts by the beginning of the text. Thanks! |
#3
|
|||
|
|||
Sort a column (specifically email data) by end of text, not beginn
Assuming that Column A contains your data, enter the following formula
in B1 and copy down: =RIGHT(A1,LEN(A1)-FIND("@",A1)) Then, select Column A and Column B, and sort by Column B. Hope this helps! In article , "Zip code help" wrote: One of my files contains a field of Emails. I want to sort it by the ISP, not the beginning of the text. so if an email is , I want to sort it so I can view all the , etc. -- the only way I know how to sort is by Ascending/descending and it sorts by the beginning of the text. Thanks! |
#4
|
|||
|
|||
Sort a column (specifically email data) by end of text, not beginn
On Fri, 14 Oct 2005 09:14:09 -0700, "Zip code help"
wrote: One of my files contains a field of Emails. I want to sort it by the ISP, not the beginning of the text. so if an email is , I want to sort it so I can view all the , etc. -- the only way I know how to sort is by Ascending/descending and it sorts by the beginning of the text. Thanks! Use a helper column to extract the ISP. If email names are in A1 enter in B1 =RIGHT(A12,LEN(A12)-FIND("@",A12)) copy down as appropriate then sort on column B HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#5
|
|||
|
|||
Sort a column (specifically email data) by end of text, not be
I can not get it to auto fill. I put the code in and wanted to drag and drop
for the remaning fields, but will not copy to the next number. Any ideas? Thanks "bpeltzer" wrote: Create a 'helper column' in which you tease out the ISP. Ex: if the email address is in A2, enter =RIGHT(A2,LEN(A2)-FIND("@",A2)) in B2 to calculate just the ISP. Autofill that formula to each row, then sort based on the new column. "Zip code help" wrote: One of my files contains a field of Emails. I want to sort it by the ISP, not the beginning of the text. so if an email is , I want to sort it so I can view all the , etc. -- the only way I know how to sort is by Ascending/descending and it sorts by the beginning of the text. Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
How to download new email to old outlook data file? | the Fiddler | General Discussion | 5 | June 6th, 2005 05:46 PM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
Column E cell contents added into Column D contents (not overwriting data but mixing) | creativetechguy | General Discussion | 2 | August 5th, 2004 07:32 PM |