How to get url from the description in a cell to be copied to another cell.

Hi,
If suppose we have 2 columns A and B. In the column 'A' we have some data in the form of paragraphs. Each and every paragraph consists of a url (for example: www.google.com). Now i need the formula which is used to get the url from column A and paste it in the corresponding cells of column 'B'.

Please help me with this.....

Thanks & Regards,
Rajesh.............

You need to explain your question some more. Maybe attach a sample file.

Thanks for the reply. Here is the file 'Sample.jpg' file attached. It consists of two columns A and B. Column A consists of Some Content in the form of paragraphs. These paragraphs consists of some Url's, which i have mentioned it in bold letters. In the next column B, i have copied those Urls. I have suppose 1000 paragraphs in column A, then its difficult to copy each url and paste it in column B. So i need some formula which copies these url from cell in column A to cell in column B.

Sample.jpg

Why post a picture of your workbook and not a sample of the workbook itself? ...

Try in B2

Please Login or Register  to view this content.

Thanks Marcol. It works perfectly. I am very much impressed by your answer.

1/.

It works, but only for a single row. I need for all the rows.

Drag the formula down as far as you need.

2/. From Forum Rules, you should read them.

Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[EDIT]
This now looks irrelevant, you have edited Post #5
Please don't change posts completely, add an edit as an explanation.