How to save hyperlinks when saving excel to csv?

T

Think With Your Head2015-06-23 13:42:32

HTML

Think With Your Head, 2015-06-23 13:42:32

There is a large table with a bunch of hyperlinks like:
=HYPERLINK(" https://link.com/product ";"PRODUCT")
How to save in csv saving these links?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

T

tplus, 2015-06-23
@tplus

Alternatively, first extract the value:
www.excel-vba.ru/chto-umeet-excel/kak-poluchit-adr...
forum.developing.ru/showthread.php/14797-Excel.-%D...
Then already save csv.
It is better to do it on a copy of the original book, so as not to spoil the source)