How do you insert data to another cell using an Excel formula?

Answer 1

A formula cannot change the contents of a different cell to itself.


Here's a method that might fill the bill:

1. Paste an object into the spreadsheet. I selected a smiley face from the auto shapes. It can be anything. All it will do is function as a button...heck, there are even buttons that you can paste in.
2. Next, right click the object and select assign macro.
3. When the macro screen comes up, you select "Record Macro"
4. Select the cell that you want to provide data.
5. Copy the data
6. Paste the data where it is supposed to go.
7. Turn off the macro recorder.

Every time you click the object it will repeat the above action.

The macro will look something like this:

Sub SmileyFace1_Click()
'
' SmileyFace1_Click Macro
'

'
Range("C4").Select
Selection.Copy
Range("E4").Select
ActiveSheet.Paste
End Sub

Answer 2

I am not sure why you would do so, but here is an option: =B3&" & "&C3