I want to put multiple hyperlinks in one cell. I have a cell that has a list of problems and I want each one hyperlinked to a picture. I have the following hyperlink I am using =HYPERLINK($B$1&""&"pic1.jpg","jpg1.pic") and it works fine when it is in a cell by itself. But to put multiple links in one cell I need to add text boxes when I do this the hyperlink above no longer works. I get the message " The formula is missing a range reference or a defined name".
Is there a different way to create multiple hyperlinks in one cell or is there a way to make that hyperlink work in a textbox?
Is there a different way to create multiple hyperlinks in one cell or is there a way to make that hyperlink work in a textbox?
