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

  • Thread starter Thread starter HelpMeCode
  • Start date Start date
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!
 
Data>Text to columns>Delimited by other....type in @

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


Gord
 
Back
Top