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

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!

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

Not knowing what "first part" and "rest" means I'll make a sugesstion.

DataText to ColumnsDelimited by "something" then choose to skip the
column after "something".

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


Gord


On Fri, 22 Jun 2012 13:40:24 -0700 (PDT), John
wrote:

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!

Column full of email addresses: how to truncate to just partof each email address (before the "@")
 

On 23/06/2012 8:22 AM, Gord Dibben wrote:
Not knowing what "first part" and "rest" means I'll make a sugesstion.

DataText to ColumnsDelimited by "something" then choose to skip the
column after "something".

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


Gord


On Fri, 22 Jun 2012 13:40:24 -0700 (PDT),
wrote:

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!

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.