Please help me How to insert txt into a list of text

[danielsantos]

Hi everyone,

Please help me how to insert words (Like "* *"") into the domain of the email lists.

ex. domain of the email is gmail.com
It should look like this:

Like "*gmail.com*"


I already know how to extract domains from email and

I have 5000 domains to be filtered out from my mailing lists it would take time for me to add those characters one by one to 5000 domains:

ex:

domains:
aapt.net.au
abv.bg
att.net
bellsouth.net
bigpond.com


it should look like these:

Like "*aapt.net.au*"
Like "*abv.bg*"
Like "*att.net*"
Like "*bellsouth.net*"
Like "*bigpond.com*"

[TMS]

With a Helper column, maybe:

="Like ""*"&A2&"*"""

Then Copy and Paste Special | Values


Regards