sort data in columns

J

jb

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
 
N

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
 
K

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
 
Top