The formula didn't work can you explain it to me in a different way?

Thanks

Kj

"tiah" wrote:

hello !

put this in another column, it will retrieve the right part of the
email. then sort that result column

=RIGHT(A1;LEN(A1)-SEARCH("@";A1))