Hyperlink & Non-Hyperlinked Text in Same Cell

    Hello,[SIZE="1"]<try to phrase that title logically!>[/SIZE]


    If, say cell A1, contains text such as:
    "This Forum is wonderful, to see a great example for a post [COLOR="Blue"]click here[/COLOR]." [SIZE="1"]<This is not an actual link here!>[/SIZE]
    Is it possible to have the "click here" part as a hyperlink, and not the entire cell?
    Or- do i have to add an "image" or something similar to which i can add the hyperlink and then anchor the "image" to that cell?


    Stefan

    Re: add hyperlink to part of cell text, not entire cell


    Stefan,


    No I don't think so. When you point at a cell you are pointing at an object. You don't actually point at the contents of the cell.


    I think the closes that you will come is the following. Though the hyperlink is only active when you actually point to the cell that contains it.


    If the text spills over to the adjoining cells you still have to point at the cell that contains the formula.



    ="This forum is a wonderful place " & HYPERLINK("www.ozgrid.com","Click Here")

    Re: add hyperlink to part of cell text, not entire cell


    Hi Barry,
    Thank you. I was afraid that this would be the case. I've already considered using a drawing object/text box and will add the hyperlink to it. Should be good enough. - Yet, other suggestions are always welcome.
    Stefan

    Re: add hyperlink to part of cell text, not entire cell


    Here is another work-around


    1) I any cell Enter This forum is a wonderful place and size Column to fit the text AND Click Here


    2) In another column AND cell Enter Click Here and create a Hyperlink (not with HYPERLINK function) Size this column so it just fits.


    3) With this cell (step 2) Active, copy it. Select other cell (step1) hold down Shift and go to Edit>Paste Picture. Move in place within the cell, far right.


    4) Right click on the Click Here picture and choose Hyperlink

    Re: Hyperlink &amp; Non-Hyperlinked Text in Same Cell


    Hi Dave,

    Quote

    Here is another work-around....
    2) In another column AND cell Enter Click Here and create a Hyperlink (not with HYPERLINK function) Size this column so it just fits.
    3) With this cell (step 2) Active copy it. Select other cell (step1) hold down Shift and go to Edit>Paste Picture. Move in place within the cell, far right.


    This is interesting. I have some questions please.


    Why, if a hyperlink is added to the cell in step 2) lets call it A2 and the text font is blue/underlined, does it not insert under 3) an image that shows the same blue/underlined font but a black and white picture? Did you mean to select 'Paste Picture Link' which does seem to give a true (colored) picture of A2.


    I found that, while using 'Paste Picture Link' i cannot delete A2 as it would render the picture link with an empty box (but keep the hyperlink) and using the 'Paste Picture' allows to delete A2 maintains the picture (and the hyperlink) - but the black and white kind.


    I couldnt find documentation in Excels Help, in MS KB or MS elsewhere for "shift+edit"... but did not have time to read all billions of hits and articles that were returned with any wild guess and content about Shift and edit that were not even closeley related - no surprise(?). Do you know where i can find more info about this (undocumented) "shortcut"?


    And lastly, what do you mean by "...Active copy...", is there an "inactive" one too?


    Thank you,
    Stefan

    Re: Hyperlink &amp; Non-Hyperlinked Text in Same Cell


    Did you try it? It worked as avertised for me.


    Point 3, should read


    3) With this cell (step 2) active, copy it. Select other cell (step1) hold down Shift and go to Edit>Paste Picture. Move in place within the cell, far right.

    Re: Hyperlink &amp; Non-Hyperlinked Text in Same Cell


    Hi Dave,
    When i add the hyperlink in step 2, the font in that cell is blue/underlined. When i copy it, and then Shift-Edit-Paste Picture, it shows in black and white. - The only thing strange and "not working" is that the picture does not represent the colors of the copied cell. Otherwise performs as advertised.
    Stefan


    p.s.
    In fact, any text color-formatted cell gets pasted in black and white, not in color.

    Re: Hyperlink &amp; Non-Hyperlinked Text in Same Cell


    Hmm, that is strange. In your Workbook example, I replaced the hyperlink in A3 with a copy paste picture it is in full color. Perhaps try on another PC?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login