try
=HYPERLINK("http://www."&a1&".com")


--
Don Guillett
SalesAid Software

"Shani" wrote in message
oups.com...
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