Clean text before the @ sign in an Email Address

[Twardil]

I need some help in cleaning up a database of email address'. I have a
spreadsheet from a supplier that has 5164 records. Each line contains an
email address- contact First name and contact last name - company name.

The problem is that some of the records contain a company name and some do
not. I can get the company name from the email address but I am hoping not to
have to look through each address.

Does anyone know of a formula that I could use to strip off the characters
before the @ sign of the email address. I could sort by what remains and be
able to complete the spreadsheet a lot easier. I thought of using the left
formula but the problem is that names are different characters in length so
that won't work.

Any help would be apprciated.

 

[Gary''s Student]

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

so if A1 contains
1234@5678

the formula will display
@5678

 

[Dave Peterson]

You could copy the column(?) to another column and then

Select that new column
Edit|Replace
what: *@
with: (leave blank)
replace all

If you wanted to discard the domain and @ sign:
Make another copy of the original column
Select that new column
Edit|Replace
what: @*
with: (leave blank)
replace all