Is it possible to use a formula or script to extract a "formatted" hyperlink from text in a cell into a new cell in the same row?

Hi... thanks for your question. I'm not sure exactly how to articulate it.

The cell content is text... select text and add hyperlink. I want to extract the hyperlinks that have been added to the text in this manner.

What I've got is long series of rows where columns are business name, city, address. Business names are hyperlinked... I want to put that link into it's own column where the actual link info is the data.

So I'm not sure then if the text is actually a "data element" associated with the cell or if it is an attribute like bold/italic or...?

darren

Ok... here's a cropped screehnshot

The rows in the top half of the page show the data where I have manually pulled the url into the third column.

First column - company name

second column - location

third column - I have been manually pulling the url and pasting it into this column

One the active line with the data "Boreal Camp Services & Outfitting" I have selected the text and hit Command-K to show the hyperlink associated with the data.... and that's the dialogue that opens. I have simply been copying the url from this point and pasting it into the third column.

So... the question is... can I somehow create a script/formula/automator that will do this across the entire sheet?

I tried to record using automator... didn't work... but I don't really know what I'm doing there.

d

Thanks for your thoughts... but I may have just come up with another work around.

By pasting the data into a Word doc and showing fields, it shows the link data instead of the name with the link "formatted" to it. So I'll have to massage it a bit to clean up, but that's just a matter of running a series of find/replaces.... then I can paste it back in.

But thank you... you seem to have confirmed what I thought... that the link is not being treated as data but rather as some kind of attribute or ??

cheers and thanks for your time

darren