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!