Forum Discussion

Mehran1359's avatar
Mehran1359
Copper Contributor
Feb 23, 2023

Copy and Past a Cell Content in another cell with formula

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 

excel
Formulas and Functions

3 Replies

  • FikturFox's avatar
    FikturFox
    Brass Contributor
    Feb 23, 2023
    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
    • Mehran1359's avatar
      Mehran1359
      Copper Contributor
      Feb 23, 2023
      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.
      • FikturFox's avatar
        FikturFox
        Brass Contributor
        Feb 23, 2023

        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.

Resources