Hyperlinking an entire column of domains

[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

 

[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
(e-mail address removed)

 

[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.

 

[Dave Peterson]

Use
=hyperlink(a1)
in B1
then select B1 and copy it down the column.

 

[anjanesh]

Ah..Thanks very much !