Hyperlinking an entire column of domains

A

anjanesh

Hi

I have a column containing text like *http://somedomain.com* but its
not hyperlinked. How can I select the column and convert to hyperlinks
? I know for each cell, on editing if I hit the ENTER key, it gets
hyperlinked. But how do I do that for an entire column ?

Thanks
 
N

Nick Hodge

anjanesh

Could you use the column next to it and the HYPERLINK function? e.g.

=HYPERLINK(A1)

and then copy the helper column data and paste special it over the original

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
A

anjanesh

Ah...something like that - it works for one cell.
But I tried selected column B and entered *=HYPERLINK(A1:A100)* but
only B1 gets A1's link. B2 to B100 are still empty.
 
Top