exporting a hyperlink

[John Milward]

Hi

I am trying to export a hyperlink field from an access 2000 database to
Excel.
In Access it is fine and the hyperlink works.
What I get after an export is the name followed by the text of the address
to link to, but it is no longer a hyperlink.
I can see no way of formating the cell in Excel to be a hyperlink
Is there any way to resolve this?

TIA

John

 

[John Milward]

OK
I have resolved this.
I used the Excel text functions to extract the strings and then the
HYPERLINK function to re-create the hyperlink.
A bit long winded (five functions in all!), but it works.

If anyone knows a better way please let me know.