I keep forgetting how I did this and having to dig into old demo VMs – you can display hyperlinks via calculated columns:
Yup, the AnimalName column is calculated, and consists of a URL and a search term which is the item’s title:
Although it doesn’t show it, [ID] is also a valid column to insert.
Sadly, I’ve not figured out how to display a ‘pretty’ calculated column yet – for example one that just showed ‘Click me‘ rather than the full URL. Still, I thought that having a link to search was interesting. And naturally, if you use the DataView web part then setting up the link with a ‘pretty’ link is trivial.
Andy Burns' Blog 
Try this Andy.Seems interesting
But i haven’t really got it to work yet.
http://pathtosharepoint.wordpress.com/2008/09/01/how-to-open-hyperlinks-in-a-new-window-or-not/
Let me know how you go
@Patrick you’re welcome to contact me if you have any issue with my method.
@Andy yes, the method mentioned by Patrick will provide “pretty links”. btw my blog has many other posts with pretty calculated columns 🙂
it works half good to us….
if the title = hello sharepoint world
my url is rendering like = http:/test.com/pagename.aspx?refurl=michael collins
where the hyper link is enabled only till michael
and collins is looking like a plain text
Yes, that is a bit of a problem – I’m afraid I don’t know the answer.
Thanks for helping me figure this out!
Formula:
=”http://vm-moss2007/sitename/Lists/listname/DispForm.aspx?ID=”&ID