Cut and Paste Data instead of Function Text

  • Thread starter Thread starter HisHighness
  • Start date Start date
H

HisHighness

Hi, I'm just wondering if there is a way I can cut and paste the results
of functions that are outputted from Excel instead of the functions
themselves?

Example:
say A1 was function =(2+2)

Is there a way I can cut and paste it in to A2 as 4 instead of =(2+2)
?

Thanks.
 
There's a built in function, 'Paste Special'
Right click and copy the cell, right click again, select 'Paste Special',
check 'Values', OK.
As you can see there are various other options other than values,
Regards,
Alan.

"HisHighness" <[email protected]>
wrote in message
news:[email protected]...
 
When you paste, select Edit > Paste Special...
and then check the Value button
 
Don't know about cut but if you copy you can use

Edit > Paste Special > Values
 
Cut or copy, don't matter, long as I don't have to move it all by hand.
;)

Thanks.
 
i suppose it's just cause it's midnight, but if you want the values, but
just somewhere else, why not use

=a1

????
 
You must log in or register to reply here.

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

Similar Threads

Cut & Paste in Excel without erasing cell borders? 1
Protection from cut and paste 6
Moving a bunch of data 1
Paste failing after cut 7
Cut and paste from web pages, emails, is breaking up text into multipleExcel cells 3
Cut and paste macro 1
My cut and paste to my web site, converts to text and not visual 3
Protect formula against cut & paste 5

Back
Top