![]() |
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? |
All times are GMT +1. The time now is 01:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com