| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column of email addresses: how to just use the part before the "@" | Excel Programming | |||
| Extracting all Email addresses from an Outlook folder"Undeliverables" | Excel Programming | |||
| "Send Email" macro to multiple addresses | Excel Programming | |||
| copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) | |||
| debug.print range "full" address | Excel Programming | |||
![John[_147_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
