Well, you jusdt named bunch of function. I think you should be more focused on your problem: How to create hyperlink from a text
Maybe this?
=HYPERLINK("http://www.caravanclub.co.uk/CaravanClubApps/Applications/UK%20Sites/CalendarResult.aspx?site="&
SUBSTITUTE(A3," ","+")&"&arrivalDate=16/09/2011&departureDate=19/09/2011")
Never use Merged Cells in Excel
Hi Martin / Zbor - thanks both for your suggestions. I'll try them out now and report back. Hope that you are both well. How's that beautiful bbq of yours Z?
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks