I am very new to Excel so please excuse the limited knowledge of asking this question within this community.
I have a Column that contains websites in each row. I need to remove ALL details except the final domain.
Basically, only need domain data AFTER the following phrase: url=
Some ROWs include the WWW while others simply have the domain. Note. Each ROW is different domain, the only element the same is the url=
Here is examples. note: I have changed the domain/url to respect the privacy.
COLUMN A:
A1: http://www.originalsource.com/goto.p...w.domain1.com; (only need www.domain1.com)
A2: http://www.originalsource.com/goto.p...w.domain2.com;
(only need www.domain1.com)
A3: http://www.originalsource.com/goto.p...rl=domain3.com
(only need domain3.com
etc
I look forward to your reply and thank you in advance for your feedback.
Please try to keep the answers very detailed (step by step) because of my limited excel knowledge.
Bookmarks