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

  • Thread starter Thread starter John
  • Start date Start date
J

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!
 
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
 
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
Click to expand...

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.
 
Back
Top