How can I change multiple text cells into multiple URL references?

[ostbits]

`LO 7.4.3.2
I have a spreadsheet with multiple lines containing a single cell with text for a URL. I’d like to change all the text into URL reference, e.g., ctl-K, without doing it manually. Is there any way to do this or do I have to do it all by hand?
thanks

[EarnestAl]

For text in cell A1 you could enter in Cell B1 =HYPERLINK(A1), see HYPERLINK

[ostbits]

Thanks. Such an easy thing to do!