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

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

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

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