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

[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!

 

[Gord Dibben]

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

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


Gord