CREATING HYPERLINK IN EXCEL

S

STARFINANCIALGROUP

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

SteveG

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 se
to automatically create a hyperlink when a web address is typed in
cell, you'll have to remove the hyperlink. Right mouse click on B1 an
select "Remove Hyperlink". This converts the address into regula
text.

In C1 & D1 is where you can type in more parts of the link in you
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 fi
your needs.

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

Does that help
 
Top