Importing Text; Ending Up w/ Hyperlinks

[bonzo]

I have a tab-delimited text file with some absolute URLs as intended cell values. When I import the data, the cell values are nothing more than text. If I select the file and then select another file, the URLs change to active hyperlinks -- which is what I wanted to begin with. I presume that this is because of the "AutoCorrect - Replace as you type" feature.

Anyway, I've temporarily worked around this annoyance by altering the import data to use the =HYPERLINK() worksheet function. However, I would prefer to just import the data as is and end up with active hyperlinks.

Is there a way to do that? If so, what do I need to do to make that happen?

Thanks...

 

[NateO]

Howdy Bonzo, you could try running a vba procedure to light your text up:

<pre>
Sub Macro1()
Dim n As Range, cl As Range
Set n = ActiveSheet.[a1].SpecialCells(xlCellTypeConstants)
For Each cl In n
cl.Hyperlinks.Add Anchor:=cl, Address:=cl
Next
End Sub</pre>

The appropriate range can be trimmed as well...