CREATING HYPERLINK IN EXCEL
 

I have tried to use a hyperlink and add cell information to the hyperlink.
The hyperlink text pulls up the web page, but the cell information pulls up
the location, rather than the information requested. ie:
http://cars.com/ford/taurus, to find the ford taurus in cars.com. I put on
the excel sheet a workbook to change the make and model and insert it in the
hyperlink. If make was in cel a1 and model was in a2, the link would send as
http://cars.com/a1+a2. Is there as way to get it to pull from this program
correctly?

Thanks,

Mark.

CREATING HYPERLINK IN EXCEL
 

Mark,

You can use the HYPERLINK function. Assuming your link is in A1.

In B1 type in the base address http://www.cars.com/. If Excel is set
to automatically create a hyperlink when a web address is typed in a
cell, you'll have to remove the hyperlink. Right mouse click on B1 and
select "Remove Hyperlink". This converts the address into regular
text.

In C1 & D1 is where you can type in more parts of the link in your
example Ford and Taurus.

Your formula would then be =HYPERLINK(B1&C1&"/"&D1,"Car Search")

The name of your new hyperlink is Car Search. You can modify to fit
your needs.

You need to make sure you incorporate any characters in the string in
the correct places or it will not work propery. You may want to put
the / in a separate cell and refer to it that way. You can then hide
any columns you don't want to see (i.e. the base address).

Does that help?


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=505411