Column Row, split some data within row cells, HOW??

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:[email protected]

A2: mailto:info@domain; http://www.domain.com/goto.php?type=...ww.domain.com;

A3: mailto:[email protected]

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.

Fill in the following formula in B1

Please Login or Register  to view this content.

Step by step:

IF( condition, value if condition is true, value if condition is False )
Evaluates the condition. If it is true the value of the 2nd argument is returned else the value of the 3rd argument.

IFERROR(expression,Value if expression gives an error value)
If the expression gives no errors the value of the expression is returned else the value of the 2nd argument.

FIND( what, where )
Returns the position in where where what is found. If nothing is found it returns a #VALUE error.

LEN( text )
Returns, you guessed it, the length of the text (the number of characters)

RIGHT( text, length )
Returns the last length number of characters from text

So if the text in A1 contains a ; this formula returns everything after that.

Thanks for everyone advising, I will attempt each of the suggestions today and let you know the results soon. Any other feedback would be helpful with these two other postings..

http://www.excelforum.com/excel-gene...ed-to-fix.html

http://www.excelforum.com/excel-gene...h-row-how.html

shukla.ankur281190 - Your suggestion was the easiest and performed as requested. Thank you.