| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate and hyperlink functions
I entered the following formula:
=CONCATENATE("Creates function, ",HYPERLINK(ProjectTrackingDB_Queries!A2)," which allows the GetSQL query to return the SQL statement of a given query.") which yields the text string one would expect it to yield. However, when I click the hyperlink I get an error, "Cannot open the specified file." Cell A2, which is referenced in the formula above has the text "GetSQL". Any ideas as to what I'm doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup returns hyperlinked values as normal text | Excel Discussion (Misc queries) | |||
| Hyperlink change address | Excel Discussion (Misc queries) | |||
| How can I change 255 character limit in 'hyperlink' function? | Excel Worksheet Functions | |||
| create hyperlink in one cell with URL in a different cell | Excel Worksheet Functions | |||
| hyperlink images in batch form | Excel Worksheet Functions | |||
Threaded Mode
