=TEXTAFTER(A2, "@")
or,
=MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))
=TEXTAFTER(A2, "@")
or,
=MID(A1, FIND("@", A1) + 1, LEN(A1) - FIND("@", A1))
Here the example is given for column A:
=COUNTIF($A$2:$A711,$A13)<2
Select Only the Blank Cells: Press Ctrl + G (or F5 ) to open the Go To dialog box. Click the Special... button at the bottom left. Sele...