| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions | |||
| displaying data within column | Charts and Charting in Excel | |||
| How can I find and sort specific data within a column? | Excel Discussion (Misc queries) | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
