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

[John]

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]

Not knowing what "first part" and "rest" means I'll 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]

Not knowing what "first part" and "rest" means I'll 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

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.