Ask Your Question

Revision history [back]

Never mind. I found the answer. Do ^A or select the portion of the spreadsheet you want to convert. Do ^H. Set regular expressions.

in the "Find" box put: (http:.*)

In the replace box, put: =hyperlink("&1")

Hit "Replace all". image description

Never mind. I found the answer. Do ^A or select the portion of the spreadsheet you want to convert. Do ^H. Set regular expressions.

in the "Find" box put: (http:.*)

In the replace box, put: =hyperlink("&1")

Hit "Replace all". all". Make these simple steps into a macro.

--Sarge image description

Never mind. I found the answer. answer:

Do ^A or select the portion of the spreadsheet you want to convert. convert. Do ^H. Set regular expressions.

"regular expressions". in the "Find" box put: (http:.*)

(http://.*) In the replace "Replace" box, put: =hyperlink("&1")

=hyperlink("&") Hit "Replace all". all". Hit "Close" Make these simple steps into a macro.

--Sarge image description--Sarge