Extract anything that has a ".com"

[Abhishek92kumar]

I have a list of texts and withing there the users mentions sometimes their email address and sometimes their websites

Also sometimes they have more than one email address and more than one urls in the same column

The column looks like

rates.https://www.etsy.com/shop/luckykaerufabric/policy?ref=shopinfo_policies_leftnav ***Orders shipped within

<tbody>
</tbody>

It has a lots of texts in between
and the user sometimes and arbitrary position places their email address and sometimes websites.

If you can separate the websites and the emails at different columns if is is present then that would be a great help.

I was thinking that email address and urls both have ".com" and after getting all the ".com" we can seperate if it is having" http" or "www" etc then it is a URL and if it has @ then a email address

A VBA code is largely appreciated

Regards


Thanks in advance

 

[drp92]

Hi,
You can use mid/right/left and find function for this, i.e if you want to extract data from this file onto other files,

and also you can use:
In Home tab-Conditional formatting-Highlight cell rules-Text that contains to highlight the data as per your text.

Hope this helps !!
Also i don't think a macro code is required for this but hey, if you have lots of data files, yes a Code does help you a lot.

 

[Abhishek92kumar]

Thanks sir for answering. But I really do need a code for this as the data are not separable using all the above .
I am not so skilled in using the above functions and also there are a few case in this situation.

Anyone with a VBA code or a formula is much appreciated

Regards