How to leave formulas in a cell.

[Matt5353]

Hi Guys.
I have a column with formulas and data in each cell.
When I copy and paste this data to another column
I want the data but not formula.
Andrew

 

[My Aswer Is This]

Copy the Range

Then right click where you want to paste and choose Paste Values

 

[Matt5353]

So simple thanks

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

So simple thanks