Calculated Column Issue with Special character [‘]

Recently one of my good friend was working with Calculated Column
He wanted to perform few actions based on this column. The formula for calculated column is as below which he entered:

=CONCATENATE(“<a target='_blank' href=‘”,”http://mysharepointserver:1234/Pages/Sample.aspx?RootFolder=&#8221;,Title,“‘>”,Title,”“)

When Title=Test’s (with special character – Apostrophe).
URL returns like :
http://mysharepointserver:1234/Pages/Sample.aspx?RootFolder=Test (actual value for Title was “Test’s”)

URL should returns like :

It was a silly mistake only. The correct formula is :
=CONCATENATE(“<a target='_blank' href=“””,”http://myserver:1234/Pages/Photo%20Gallery.aspx?RootFolder=&#8221;,Title,“””>”,Title,”“)

See below snap :

Hope this will help others also!!!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s