B1: =Hyperlink("http://www." & a1 & ".com")
then drag fill down the column.
--
regards,
Tom Ogilvy
"Shani" wrote:
I have a column with links but would like to create a new column with
the urls they are point ting to
for example
A1=google but the hyperlink is www.google.com
I would like B1=www.google.com
A2=yahoo but the hyperlink is www.yahoo.com
I would like B2=www.yahoo.com