If I have cells A1-A5 as these IP addresses:
http://12.23.34.11
http://12.23.34.12
http://12.23.34.13
http://12.23.34.14
http://12.23.34.15

and they are not hyperlinks yet, is there a way to get Excel to insert a
hyperlink where the hyperlink will automatically point to the contents of
the cell itself ie. the hyperlink in cell A1 should "http://12.23.34.11" and
so on?

I know you can do this manually, but the automatic option would save a LOT
of time.

Thanks,
Alain