Sandoval's SharePoint Spot » Create a hyperlink with a label and not displayed as a URL string

9
Feb 10

Create a hyperlink with a label and not displayed as a URL string

  Posted by Sandoval

  0 comments

Below is a sample from http://pathtosharepoint.wordpress.com/2008/09/01/how-to-open-hyperlinks-in-a-new-window-or-not/

=CONCATENATE(”<DIV><a href=’”,”http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.”,Title,IF([Open in new window?]=TRUE,”‘ target=’_blank’ “,”‘”),”>”,Title,”</a></DIV>”)

Go to the main page

  Calculated Columns, Functions and Formulas

  hyperlinks