How to add more than one hyper link into single cell in excel.?

Question

I want to display say two links in a cell. say "Link1", "LInk2" are 2 words present in a cell. And "Link1" should have "www.yahoo.com/link1" and Link2 should have "www.yahoo.com/link2". I tried to use like =HYPERLINK("www.yahoo.com/page1", "Link1"), HYPERLINK("www.yahoo.com/link2", " Link2") but it don't work.. Can any body please help me in finding the kind of formula separator in Excel.

Answer 1

i dont think that u can do it