Forum Discussion

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

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

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