Column of email addresses: how to just use the part before the "@"

H

HelpMeCode

Hello,

we have a column with a few hundred email addresses. It's not safe to email these across, in case they fall into handsof spammers, but we still need to retain part of the information.

Is there a way to clone the column but only keep PART of the email address?

(email addresses are from a variety of domains, from around the word)

Thanks very much!
 
G

Gord Dibben

Data>Text to columns>Delimited by other....type in @

In step three choose to "skip" the right side column.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column full of email addresses: how to truncate to just part of eachemail address (before the "@") 2
Huge spam operator accidentally leaks database of 1.37 billion email addresses 4
send email to email address in column 2
List of email addresses 2
Transposing hundreds of addresses in a column using VBA 7
Comparing two columns with email addresses 2
How to extract email addresses to new column 4
Rows To Columns & Hyperlink to Email Address 0

Top