Multiple URL's from one Cell into one URL per Cell

[plasma33]

Hi Guys,

I have multiple Web Links and some other contents in one cell, I need that to be put into one link in one cell at a time. I am fine if we get rid of other contents other than links. Please suggest me with some code. I am attaching the excel file. Please find the attachment.

Thanks in Advance.

Cheers
VJ

[JBeaucaire]

A proper sample workbook would have BEFORE/AFTER examples, and in this case, I'd think several of them would be in order as I'm sure your "cells" would be in varying configurations. Show us all those variations and what specifically would be kept/discarded in each example.

[plasma33]

Hi JBeaucaire thanks for your kind reply....I used the below code to extract the URL's from a web link..here is the code->

Please Login or Register  to view this content.

And the output that I get when the above code is executed is given in the above uploaded excel file.

I just want to extract "http://msbi.ipb-halle.de/MetFusion/icefaces/resource/ODY3MzQyNTcy/MetFusion_Results_04-08-2012_13-43-40.xls" from the url's that I have given in the above uploaded excel file.
I don't want to do anything else. And the "04-08-2012_13-43-40" from the above link will be dynamic at all times.

thanks in advance.

Cheers
plasma33

[plasma33]

Thanks in Advance....

Cheers
plasma33

[JBeaucaire]

This formula seems to pull out that string for you:

=MID(A2,FIND("http:",A2),FIND("javascript",A2,FIND("http",A2))-FIND("http",A2))

[plasma33]

Thanks for the code mate...can we do that in macro????

Cheers
plasma33

[JBeaucaire]

Yes, you can record formula that into a macro in about 10 seconds, right? Turn on the recorder, enter the formula into cell A1, then do a copy/pastespecial>values on A1, stop the recorder.

Report your successful creation of the macro back here.

[plasma33]

Thanks for the tip mate..Here is my code...but when I get my output I get it with the quotes...do you know how to get rid of the quotes???

Please Login or Register  to view this content.

Cheers
plasma33

[JBeaucaire]

I ran your macro on the sample sheet above, no quotes. So no way to see what you mean.

You can try this to get just the values, removing the formula:

Please Login or Register  to view this content.

[plasma33]

thanks for the code....worked perfectly....

Cheers
plasma33