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

Hello,

we have a column with a few hundred email addresses. it is 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