View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gene[_2_] Gene[_2_] is offline
external usenet poster
 
Posts: 3
Default Getting data from two cells to make a hyperlink

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.