How do I "paste" a hyperlink into a cell...

How do I "paste" a hyperlink into a cell...

Question:

I need to paste a hyperlink to a PDF document (example: http://www.adc.com/pdf/1234567 ) into a specific cell in a column whose data type is set at "URL".

Note: I can enter the link manually into the cell so I know the link works... however due to the length of the link this is impractical.

Any assistance would be greatly appreciated.

Thank you.

Michael