Thread: Column full of email addresses: how to truncate to just part of eachemail address (before the "@")
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
  
Posts: 621
Default 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!
Reply With QuoteReply With Quote