Convert Function Result To Plain Text

[Questor]

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.

 

[Stefi]

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:

 

[Faraz A. Qureshi]

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 special>values.

 

[Dave Peterson]

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.