Abhishek92kumar
New Member
- Joined
- Sep 1, 2014
- Messages
- 2
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
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]rates.https://www.etsy.com/shop/luckykaerufabric/policy?ref=shopinfo_policies_leftnav ***Orders shipped within[/TD]
[/TR]
</tbody>[/TABLE]
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
Also sometimes they have more than one email address and more than one urls in the same column
The column looks like
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]rates.https://www.etsy.com/shop/luckykaerufabric/policy?ref=shopinfo_policies_leftnav ***Orders shipped within[/TD]
[/TR]
</tbody>[/TABLE]
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