이메일에서 도메인을 얻는 방법

If your email address is in cell A1 (top left cell) the formula to use to get just the domain part is as follows -

=RIGHT(A1,LEN(A1)-FIND("@",A1))

This works for all versions of Excel.