| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort starting from a specific character (@ sign) for email addres
I am trying to sort a very large list of email addresses, and I want to start
the sorts from the "@" symbol in each address. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sort starting from a specific character (@ sign) for email addres
Insert a column next to your original data and enter the
following formula and copy down as far as you need to go. =MID(A1,FIND("@",A1)+1,LEN(A1)) Then sort by this column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "RobJ" wrote in message ... I am trying to sort a very large list of email addresses, and I want to start the sorts from the "@" symbol in each address. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Excel Column on Fifth Character | Excel Worksheet Functions | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| Find a character to sort on in an Excel cell if not the 1st charac | Excel Worksheet Functions | |||
| I want to sort Data A-Z starting at Cell A1 to C34 | Excel Discussion (Misc queries) | |||
| How can I find and sort specific data within a column? | Excel Discussion (Misc queries) | |||
Hybrid Mode
