URLs export to Excel with # signs

[doctorswamp]

Hi

When I export a query to Excel the web addresses appear enclosed in hash signs

eg #

http://www.bbc.co.uk#

How can I stop this?

Thanks

 

[PHV]

Have a look at the HyperlinkPart function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886