When I have merged two cells, one cell is from a Concatenation of
another cell, trying to form a hyperlink, I get a error that the
linked file is not there. When, I look to see the hyperlinked cell it
is showing the Concatenation and not the disply. Any help to convert
the Cont. cell to the value and not the formula.