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

[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

 

[Bob I]

The hyperlinks in column C should remain hyperlinks. Are they changing?
Or are you replacing them?

 

[Larry]

They are changing by themselves

..

The hyperlinks in column C should remain hyperlinks. Are they changing?
Or are you replacing them?




- Show quoted text -

 

[Bob I]

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.

 

[Larry]

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.

 

[Bob I]

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.

 

[Larry]

formula is in L1. not that it matters. I see i am getting no where
here.

 

[Bob I]

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?