Copy and Past a Cell Content in another cell with formula

New Contributor

Hi Guys,

I was wondering if you can advise me on how can I copy and paste just the value of one cell into another cell using an excel formula.

Thanks 

Mehran 

3 Replies
I don't know what you are trying to do or what you want to achieve. But you can just use cell referencing.
ie. If you want to copy values of cell A1 to cell B1, in B1, just enter =A1
Thanks for your reply. With this method, I am moving the cell A1 formula to Cell B1.
I am looking for a method to just copy & past the value of cell A1 to B1. Exactly the same as when we copy and paste only the cell value.
I like to break the connection formula between A1 and B1.

@Mehran1359 

If that is the case, a formula cannot do this. Instead, use macro/vba script.
ie

Sub Test()
Range("B1").Value = Range("A1").value
End Sub

This procedure will copy the value in A1 to B1.