How do I create a link that when you type in the cell, it adds the text to the end of the link?
I.E.
I type 123 in cell, it then creates a hyperlink to http://www.mysite.com/123 and displays 123 in cell.
I type 931 in cell, it then creates a hyperlink to http://www.mysite.com/931 and displays 931 in cell.
I.E.
I type 123 in cell, it then creates a hyperlink to http://www.mysite.com/123 and displays 123 in cell.
I type 931 in cell, it then creates a hyperlink to http://www.mysite.com/931 and displays 931 in cell.