Creating multiple links to cells from within a single cell

  • Thread starter Thread starter murph-a-mong
  • Start date Start date
M

murph-a-mong

I would like to have a single cell that contains several different links
to different cells in the same workbook. E.g. the cell conatins some
text and I would like a few words within this text to act as links to
specific cells. I have managed to create a text hyperlink within a cell
to another cell but it won't let me create more than one hyperlink or
enter ordinary text which I don't want linked. E.g. an example cell
would contain the follwing text: "Revenue generated this year. Revenue
generated last year." I would like to create links for "this year" and
"last year" so that they reference different cells. All help
appreciated or any ideas of different methods.

Rgds
 
With your two values in E1 and E2, in any other cell:-

="Rev This Year "&E1& ", Rev Last Year"&E2

etc
 
and if you wanted the numbers formatted:

="revenues generated this year: " & TEXT(A1,"$#,###.00") &
"revenues generated last year: " & TEXT(b1,"$#,###.00")

(all in one cell.)
 
Back
Top