Extract anything that has a ".com"

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



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
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

drp92

New Member
Joined
May 23, 2013
Messages
17
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

New Member
Joined
Sep 1, 2014
Messages
2
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,367
Messages
5,601,214
Members
414,434
Latest member
Riyen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top