Need to convert text to hyperlinks

Keith,

Let's say your URLs are in column B. In column C you can fill with the expression: =HYPERLINK(B,B)

You can then hide column B and see your links in C.

Jerry

A shorter method from what I posted earlier is

1) Find&Replace All // with // (this seems to set it up so this method works)
2) Double click cell
3) Double click next cell
4) etc.

Make sure it is hyperlinking the entire URL. During my tests it didn't always hyperlink the whole thing. I found that if I clicked on top of the "http" it usually worked but it was not always necessary.

Kburtis wrote:
I have a column of imported data that has hundreds of web adresses. http://www. mysite .com kind of thing. I need to convert all of these so that they are clickable and hyperlinked. Is there an easy way to format the cells so that this could be made possible?
Thanks
Keith

Hi Keith,

Welcome to Apple Discussions and the Numbers '09 forum.

"Using Hyperlinks" and "Linking to a Webpage" are discussed on Page 184 of the Numbers '09 User Guide. The well-written guide, and the equally useful iWork formulas and Functions User Guide may be downloaded though the Help menu in Numbers.

Regards,
Barry

Offhand I don't know how to do hundreds of them in a single step. If it was just a few, you can do it by

1) Click the cell (to select it)
2) Cmd A (to select all the text)
3) Cmd X (cut it)
4) Cmd V (paste it back in)
5) Return (to move to the next cell in the column)

You need the auto-correct preference setting of detecting web addresses turned on.

If I think of a way to do all of them at once, I'll let you know.