URL extraction help

**mecutemecute** · 06-08-2013, 11:26 PM

url-extraction-help.xlsx Please view the attachment I need the following three urls extracted from the code listed in the column A outputting to column B, C, D in this exact order.

PLEASE HELP! THANKS!

**mecutemecute** · 06-08-2013, 11:27 PM

FYI, if no URL exists then empty value should display.

**FDibbins** · 06-09-2013, 12:37 AM

From what I can see, your data contains no URL's?

**mecutemecute** · 06-09-2013, 09:18 AM

the urls that needs to be extracted are in the CELL A1 Please look at it again you have to scroll down within the cell to see

**mecutemecute** · 06-09-2013, 10:22 AM

Cell A has this information:

Formula:

Please Login or Register  to view this content.

I need the Columns B, C, D to output the following URL from the column A in this exact order:

http://testurl.com/test1.jpg http://testurl.com/test2.jpg http://testurl.com/test3.jpg

**mecutemecute** · 06-09-2013, 10:24 AM

Please help! I need this urgently....

**mecutemecute** · 06-09-2013, 10:29 AM

Originally Posted by FDibbins

From what I can see, your data contains no URL's?

Can you please take a look at the cell again? you need to scroll all the way down to see this. or i am copy/pasting here as well.

Formula:

Please Login or Register  to view this content.

**Marcol** · 06-09-2013, 11:23 AM

Try this workbook.

Sheet1 returns all the urls found, including duplicates.
Sheet1(2) returns 1, 3, 5, ... urls, (odd numbered instances) found.

It isn't clear from your sample what is really required. ...