in Excel, what is the formula to cut characters to the right of a symbol, as in to the right of @ in an email?

Question

I have an Excel database with email addresses. I want to understand source of emails ESPs, and cut out all ESP info to the right of the @ sign.

What is the formula in Excel where I can say "cut out all characters to the right of the @ sign and place in a new column"?

Thanks!

Answer 1

If your email address is in A2, this formula will get the ESP info to the right of the "@":

=RIGHT(A2, LEN(A2) - SEARCH("@",A2))

It finds the location of the "@", and subtracts it from the total length to find the number of characters to the right of it.

FYI, to get the name to the left of the "@", you would do this:
=LEFT(A2, SEARCH("@",A2)-1)

If you need more info, add more details or e-mail.
Cheers.
.

Answer 2

Everybody keeps giving you formulas for this one and you don't need a formula. There is a real easy way to do this.

Select your column with the email addresses then select:

Data > Text to Columns...

Choose Delimited then select click the Next button.

Uncheck all of the delimiters except for Other. Then in the blank beside Other type in the @ symbol. Then click finish.

One thing to note. Make sure you have an open column to the right of your data for the new separated data to go into. Otherwise the new column will overwrite your old data if you aren't careful.

This will do away with the @ symbol, but I doubt you really need the @ symbol in either column anyway.

Text to Columns is a really great way to separate data. You can separate based on any symbol such as a comma, period. Tor you can separate based on a tab or space. If you used fixed instead of delimited you can separate based on how long the text is in inches.

Answer 3

Right Function In Excel

Answer 4

Assume the email address is in A1
Put this formula in B1 >> =SEARCH("@",A1)
Put this formula in C1 >> =LEFT(A1,B1-1)

This will always work no matter what the length of the text is before or after the @ sign.
==========
Thought of another way... Use the Find and Replace function. Find all instances of "@*" in the column where the email addresses are and replace them with nothing.

Answer 5

Use the right function