Problems with Hyperlinks

[kaliszek]

I put a hyperlink in a cell, then I with make a new line and type something. The whole cell then becomes a hyperlink. I then highlight the line I don't want hyperlinked, click off the underline and select the right letter color, but it still stays a hyperlink.

If I do this with text before the hyperlink, it works. And if I then do the same with the text after the hyperlinik it works too.

Has anyone have the same problem? Does anyone know a way around it? I've searched and search.

 

[foodorwater]

I put a hyperlink in a cell, then I with make a new line and type something. The whole cell then becomes a hyperlink. I then highlight the line I don't want hyperlinked, click off the underline and select the right letter color, but it still stays a hyperlink.

If I do this with text before the hyperlink, it works. And if I then do the same with the text after the hyperlinik it works too.

Has anyone have the same problem? Does anyone know a way around it? I've searched and search.

maybe you could type a Single quotation mark (i.e. 'text) before a string.

 

[tonydi]

Changing the color and removing an underline is formating and has nothing to do with a hyperlink. Enter an empty cell with a 1 than select the copy the 1 and use paste special- multiplly on the destination cell this will remove the hyperlink from the cell in the new line below the hyperlinked cell.