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 emails in each row, however SOME of the rows contain the website url as well. I can't figure out HOW to separate the website into its own column while maintaining the SAME ROW because all the data within the row is associated with each other.
Here is examples. note: I have changed the domain/url to respect the privacy.
COLUMN A:
A1: mailto:contact@domain.com
A2: mailto:info@domain; http://www.domain.com/goto.php?type=...ww.domain.com;
A3: mailto:contact@domain.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.