| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I annotate the cell results from Excel to a Hyperlink?
I have a cell that has a part number in it that I have generated and I want
to go to the web to find pricing on it. I have a link to a web page for pricing and all I need to do it to annotate this part number from the cell to the end of the hyperlink that I have. How do I do this? Thanks |
|
#2
|
|||
|
|||
|
Let's say you want to add "abc" to the end of the following text
"http://www.abccorp.com/" and "abc" is in cell A1 =HYPERLINK("http://www.abccorp.com/"&A1) "kgagne" wrote: I have a cell that has a part number in it that I have generated and I want to go to the web to find pricing on it. I have a link to a web page for pricing and all I need to do it to annotate this part number from the cell to the end of the hyperlink that I have. How do I do this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
