Convert Function Result To Plain Text

  • Thread starter Thread starter Questor
  • Start date Start date
Q

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.
 
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:
 
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.
 
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.
 
Back
Top