Text String and Hyperlink

Is there a way to create a text string and convert it to a hyperlink? I guess there are two things here. First one is the text string. For example, if I wanted to use a fixed text and then add a data variable to it, giving me a combined value of the text string and the data variable as one.

For instance, the text string can be “http://findcar.com/” and the data variable can be a VIN number which is a value from a Cars data table. So I can create a new field to link the record to an outside website using the VIN number. Thus, each Car record will link accordingly to its respective VIN and return the correct page on “http://findcar.com”. Hope this makes sense.

The second item, would be to be able to convert the combined text string to a link.

Thanks.