Excel - Column full of email addresses: how to truncate to just part of eachemail address (before the "@")

Asked By John on 22-Jun-12 04:40 PM
Hello

We have a spreadsheet with about a thousand email addresses. Is there a way to JUST have the first part of the email address, and delete the rest?

Thanks!


Gord Dibben replied to John on 22-Jun-12 06:22 PM
Not knowing what "first part" and "rest" means I will make a sugesstion.

Data>Text to Columns>Delimited by "something" then choose to skip the
column after "something".

Or used the "fixed width" option if that suits.


Gord
Vacuum Sealed replied to Gord Dibben on 22-Jun-12 07:23 PM
Try this

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

It starts at A2 assuming row 1 is header, change the cell reference to
suit, copy down...

HTH
Mick.
Previous Excel Discussion:  Column of email addresses: how to just use the part before the "@"