Hi,

For data in column A put this in column B and drag down as
far as needed.
"

To make them hyperlinked use
")

HTH
Martin