Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sort data in columns
I have a spreadsheet with a large amount of data, I want to sort on a column
that has part codes in it. ie. 1xxx11111zzz, some codes have the following code structure 1xxx11111zzz@aaa who do I sort on the @aaa part of the code |
#2
|
|||
|
|||
Insert a column with the formula =RIGHT(A1,3), fill down, and use that
column as your sort key -- Kind regards, Niek Otten Microsoft MVP - Excel "jb" (donotspam). wrote in message ... I have a spreadsheet with a large amount of data, I want to sort on a column that has part codes in it. ie. 1xxx11111zzz, some codes have the following code structure 1xxx11111zzz@aaa who do I sort on the @aaa part of the code |
#3
|
|||
|
|||
use the following formula in a separate column and use that column to sort
your data: =MID(A1,FIND("@",A1)+1,LEN(A1)) or even: =MID(A1,FIND("@",A1)+1,255) as I guess the domain is unlikely to be 255 characters long. Regards, KL "jb" (donotspam). wrote in message ... I have a spreadsheet with a large amount of data, I want to sort on a column that has part codes in it. ie. 1xxx11111zzz, some codes have the following code structure 1xxx11111zzz@aaa who do I sort on the @aaa part of the code |
#4
|
|||
|
|||
I guess +1 is redundant so:
=MID(A1,FIND("@",A1),255) Regards. KL "KL" wrote in message ... use the following formula in a separate column and use that column to sort your data: =MID(A1,FIND("@",A1)+1,LEN(A1)) or even: =MID(A1,FIND("@",A1)+1,255) as I guess the domain is unlikely to be 255 characters long. Regards, KL "jb" (donotspam). wrote in message ... I have a spreadsheet with a large amount of data, I want to sort on a column that has part codes in it. ie. 1xxx11111zzz, some codes have the following code structure 1xxx11111zzz@aaa who do I sort on the @aaa part of the code |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert data from rows to columns | Excel Discussion (Misc queries) | |||
Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
How do I sort data into 2 worksheets in excel vba? | Excel Worksheet Functions | |||
Comparing Data in two columns | Excel Worksheet Functions |