I want to copy the result of a concatenate function to another cell as plain
text (cell contents is the textual result not the function statement). I
can't seem to find the function that does that. Can you steer me to it please.

There is no such a function (think it over: it's impossible), it can be done
with Copy/PasteSpecial-Values!
--
Regards!
Stefi



€ž"Questor"€� ezt Ã*rta:

I want to copy the result of a concatenate function to another cell as plain
text (cell contents is the textual result not the function statement). I
can't seem to find the function that does that. Can you steer me to it please.

How could there exist such a function? It would be again a function itself.
You may record and use a macro however for copy and paste specialvalues.
--
Thanx in advance,
Best Regards,

Faraz


""Questor"" wrote:

I want to copy the result of a concatenate function to another cell as plain
text (cell contents is the textual result not the function statement). I
can't seem to find the function that does that. Can you steer me to it please.

I would use Stefi's suggetion.

But you could use:
Select the cell with the concatenation formula
Hit F2 (to edit the cell)
Hit F9 (to evaluate the formula)
Select the text (no longer a formula) in the formula bar
hit ctrl-c to copy it
hit escape to put the formula back

And now you can paste into the formula bar for the receiving cell.

I do use this technique when I want a portion of the string copied or pasted.

"Questor" wrote:

I want to copy the result of a concatenate function to another cell as plain
text (cell contents is the textual result not the function statement). I
can't seem to find the function that does that. Can you steer me to it please.

--

Dave Peterson