Find names from text input and replace with blanks in many columns

[wonka1234]

Hi,

Say I have a text input of emails.

Louis.Stevens@hotmail.com

Ren.Stevens@hotmail.com

How can I lookup these emails within my columns(10) of another dataset and replace these with blanks?

Thanks.

[binuacs]

@wonka1234 One way of doing this with the find and replace tool

[FinnCharlton · Accepted solution]

Hi @wonka1234, you can do this with a combination of transform tools and find and replace: