Here's an issue I can across today that's got me stumped.
I've copied a very large table from a website and pasted it into excel. Most columns are text, but in one of the columns, there is a little picture in each cell. There is a hyperlink attached to each picture that is linked to individual documents on the web.
Since there is not an actual value in these cells, (just a hyperlinked picture) I am not able to do vertical lookups or other functions using these cells.
Is there a way to extract the hyperlink from these pictures and paste the hyperlinked address in an adjacent column? Also, when donig vertical lookups with hyperlinked text, is there a way to maintain the hyperlinks and not just have the result be the hyperlink text only?
There are thousands of rows, so manual copy and paste on a cell-by-cell basis will not be practical. Thanks in advance!
I've copied a very large table from a website and pasted it into excel. Most columns are text, but in one of the columns, there is a little picture in each cell. There is a hyperlink attached to each picture that is linked to individual documents on the web.
Since there is not an actual value in these cells, (just a hyperlinked picture) I am not able to do vertical lookups or other functions using these cells.
Is there a way to extract the hyperlink from these pictures and paste the hyperlinked address in an adjacent column? Also, when donig vertical lookups with hyperlinked text, is there a way to maintain the hyperlinks and not just have the result be the hyperlink text only?
There are thousands of rows, so manual copy and paste on a cell-by-cell basis will not be practical. Thanks in advance!