Can anyone help me with the syntax for coding a link into a text string? I know it includes ampersands (&) etc. but can't remember how. As an example, i would like to replace the text below in caps with syntax that will pull information from another workbook.
In the event that it is necessary to cancel EVENT NAME prior to the scheduled opening, due to any cause within the control of ORGANIZATION...
You mean something like"
="In the event that it is necessary to cancel "&A1&" prior to the scheduled opening, due to any cause within the control of "&B1&"."
where A1 and B1 hold the data to insert...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yes. I need the quotation marks too, right?
Yes you do need them
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks