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