sort data in columns

[Guest]

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

 

[Niek Otten]

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

 

[KL]

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

 

[KL]

I guess +1 is redundant so:

=MID(A1,FIND("@",A1),255)

Regards.
KL