Creating multiple links to cells from within a single cell

[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

 

[Ken Wright]

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

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

etc

 

[Jean-Paul Viel]

=CONCATENATE("Revenue this years ",A1," last year ",A2)

 

[murph-a-mong]

Thanks for the prompt response guys. Much appreciated.

Rgds

 

[Dave Peterson]

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.)