Try this formula in a blank cell where "A1" is the cell containing the email
address. =RIGHT(A1,LEN(A1)-FIND("@",A1,1))
--
Claude S
"kendraa" wrote:
I have a large document that contains thousands of email addresses. I want
to delete the part that becomes before the "@" sign, inlcuding the "@" sign
across the whole spreadsheet. EG: becomes ecollege.com
only. How can I do that?