How to import data as hyperlink

J

Joe

I have a flat file with 4 fields of data. One of the
fields I'd like to be imported as a hyperlink, so it can
easily be clicked on in the worksheet. How do I code my
flat file to make this happen? Below is an example of my
data:

<a href="http://www.something.com/data">field1</a>
field2 field3 field4

So, clicking on "field1" in the spreadsheet will take me
to www.something.com/data.

When I import my flat file now, I get all of the html
coding in the cell, and it's not a hyperlink.

Any thoughts, suggestions will be much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create timeline with event being hyperlinks to documents on drive 1
How to convert text file into excel using macro vba 2
Shift several columns in table 4
Macro attached to Autoshape Hyperlink not invoking 0
Format of CSV file not preserved when edited in Excel 2007 1
If then rules - I can't make them work? 1
255 Character limit when opening URL's, any way around it? 1
Need help in merging cells together 2

Top