Convert text to clickable URL

[THEBookMan]

I have a column of text: HTTP://UniversityofPhoenix.edu
Can I convert that to a clickable URL ?

As always, You guys are the greatest!
⌡im

[LeroyG]

Your text in A1, and =HYPERLINK(A1).

[JohnSUN]

For entire column try this

Calc: Convert text to link

Try to find the right settings to command Search & Replace [Create HYPERLINK] Update I am grateful to @GerritGriebel and @LonnieBest for pointing out the inaccuracy in this answer. Indeed, search and replace strings should be other. If the cells contain only link text, then the Find string can be as specified (.*) or just .*, the Find string must contain a ampersand sign & instead of an “ampersand-one” &1 [FR_1.png] If the cell contains link text and some kind of explanatory text, the Fin…

Yes, it was almost 14 years ago, but the principle has not changed, it should work.

[THEBookMan]

confusing …
Tried several ways, to no avail.

[LeroyG]

Replace with: =HYPERLINK("&")

[ady]

I would guess that the replacement should be performed on selected cells only.

[karolus]

@THEBookMan

Tried several ways, to no avail.

that tells nothing to the reader!

try ctrl + click

[EarnestAl]

@THEBookMan

Tried several ways, to no avail.

Note that the hyperlink function creates a clickable link but the link does not change colour. If you hover over the cell then you should see the link as tooltip. Otherwise, do as @karolus says, Ctrl+click

[THEBookMan]

Wworked perfectly !!!
Highlighted the cells I wanted converted, √ed the “CURRENT SELECTION ONLY”.

Bingo … Saved me several hours of work.

Thnak you, You guys are the GREATEST !!!
⌡im