PLease Help..Neeed Hyperlinks from cell values
 

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

PLease Help..Neeed Hyperlinks from cell values
 

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

PLease Help..Neeed Hyperlinks from cell values
 

Try this one in B1
=HYPERLINK("http://www."&A1&".com")


--
Regards Ron de Bruin
http://www.rondebruin.nl


"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

PLease Help..Neeed Hyperlinks from cell values
 

sub Extracthypelinksaddress()
Dim hlnk as Hyperlink
for each hlnk in activesheet.hyperlinks
hlnk.parent.offset(0,1).Value = "'" & hlnk.Address
Next
End Sub

the most I could add is to come to your site and run the macro.

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

PLease Help..Neeed Hyperlinks from cell values
 

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