Hi,

I believe you would need to create a VBA routine to do this, do you want that?

--
Thanks,
Shane Devenshire


"Roger on Excel" wrote:

I have hyperlinksin a column in my spreadsheet.

I would like the cells adjacent to show the actual web address.

How do i do this?

Thanks in advance,

Roger