Links turn to text after formula is run. Not a good thing :-)

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I have hyper links in some of the cells in column C when using the
below formula.
After the formula is run the links turn to text. Is there a way to
keep them as links?
=C1& " " & D1& " " &E1& " " &F1&G1
 
The hyperlinks in column C should remain hyperlinks. Are they changing?
Or are you replacing them?
 
What cell is the formula in? For me the "C1" looks like text in the
formula bar but is still a hyperlink in the Cell.
 
If the formula is in C1, then how can it be a hyperlink, and also
reference itself? There is something seriously wrong with the logic as
stated.
 
The Hyperlink in C1 will and should remain a hyperlink. What appears in
L1 would be ONLY the TEXT of the hyperlink that is in C1. Now on the
other hand formulas ar not "run" but "Macros" are, so perhaps you have
some Macro that is doing the damage?
 
Back
Top