Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I de-activate hyperlink in Excel ? | New Users to Excel | |||
Creating Hyperlink in Excel to PDF document??? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
hyperlink in Excel to Word doc closes Excel doc | Excel Discussion (Misc queries) | |||
Creating Excel bookmarks | Excel Worksheet Functions |