How to Remove the Hyperlink for a Lookup Column in a SharePoint List
- 1). Access the site with the list that contains the lookup column with the hyperlink. Click on “File” on the menu bar, and select “Edit with Microsoft SharePoint Designer.”
- 2). Enable Split view by selecting “Split” at the bottom left corner of the screen. The split view allows you to view both code and design elements in SharePoint Designer.
- 3). Right click on the list with the lookup column, and select “Convert to XSLT Data View” from the shortcut menu to change the list view to a data view.
- 4). Select a field value in the lookup column where you would like to remove the hyperlink. You should see the code behind this field value highlighted in code view. This is the code element that should be manipulated to remove the hyperlink. For example, if you are trying to remove the hyperlink for a MeetingDate lookup column, the code should appear as <xsl:value-of select=”@MeetingDate” />.
- 5). Replace <xsl:value-of select=”@MeetingDate” /> with <xsl:value-of select="substring-before(substring-after(@MeetingDate, ‘>’), ‘<’)" disable-output-escaping="yes"/> in code view. The lookup column should now appear with no hyperlinks.
Source...