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