asked on

Open office calc - Extract url from hyperlink.

I have a ods calc doc. In it are cells that have hyperlinks like this.

PICTURE
PICTURE
PICTURE

How can I extract the url information from those "PICTURE" text links?

I don't care for the "PICTURE" text, I need the url for each link.

I have thousands of links so I need a formula to get this information.

thanks!

www_puertoricoautoforo_com

ASKER

making this the htaccess file and putting it in the /recommended-sites/ directory did the trick.

DirectoryIndex links.php

Open in new window

www_puertoricoautoforo_com

ASKER

ooops, wrong question, please disregard my last reply, I still need and answer for this.

ASKER CERTIFIED SOLUTION

ltlbearand3

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

www_puertoricoautoforo_com

ASKER

Thanks for the macro, for some reason I get blank rows.. I've tried creating a new document and running the macro on a small sample of cells and I get the same result.

It creates a new sheet but the new sheet is blank.

www_puertoricoautoforo_com

ASKER

Your solution works, I found out I have bad hyper links

www_puertoricoautoforo_com

ASKER

Is there a way to do this without deleting the blank cells? Is there a way to just keep the rows intact?

I extract it from 1000 rows some of them without pictures, but I get back 522 rows. can we just extract row for row?

I'm using a spread sheet designed by some "genius" that wanted to merge all kinds of cells so I can't sort it.

ltlbearand3

Are all you URLs in one column on one sheet?