How do I remove partial data from a cell in Excel?

Question

I have a spreadsheet with full email addresses in one column. The list is 800 email addresses long. I only need the beginning of the email address and need to remove the "@company.com". I know there must be a simple way of doing this. Thank you for your help.

Answer 1

=LEFT(A2,FIND("@",A2)-1)

.

Or

use Find and replace,Replace all

https://learn-attachment.microsoft.com/api/attachments/8467a3c6-96b7-48f6-9f1b-70810a3480a3?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/f836c916-a4f5-4595-90bf-a5b598352e17?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

Answer 2

Fill in what you want in the column next to the top two entries, and then select the next cell and use

Data / Flash fill

Excel will process all the entries based on the logic it derives from your examples.

Answer 3

Hi,

You may also use the =TEXTBEFORE(A2,"@") formula.

Hope this helps.

Answer 4

OR -

You could also use Data / Text to columns Delimited Next Choose @ as the delimiter, and then in the next step, select the second column and choose "Do not import column (skip)" then finish up.