[Solved] hyperlink formula not working correctly?

[Bobo226]

I imported a CSV file into a new open office spreadsheet. Column "B" lists URLs that I want to convert from text to hyperlinks. I created the following hyperlink formula in column "C":
=HYPERLINK($B1)... then copied the formula do thru column "C"

Which appears to have worked, however when I click on any of the hyperlinks in column "C" I get the following pop-up window:

Windows cannot find ' https://google.com/ '.Make sure you typed the name correctly, and try again.

Anyone know what's causing this error/problem?

Bobo

[Zizi64]

Please upload your real ODF type sample file here.

[Bobo226]

Duh!... okay I figured it out, in my CVS I inserted a "space" after the "," & before the URL address. Once I deleted the space, everything worked perfectly.

Thanks for your offer to help, Zizi64!

Bobo