Convert Function Result To Plain Text


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.
 
Ad

Advertisements

S

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:
 
F

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.
 
Ad

Advertisements

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top