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
|