Pasting is annoying me!!

[WILFY06]

Hi Guys!!

Is there a way to paste into a cell that already contains without deleting origional cell data, in other words paste onto the end of current data, because so far taking a while to copy just text and then highlighting cell clicking on text and then paste onto end? :x anyway any help would much appreciated!!

 

[Joe4]

If you go into the cell you want to copy, and highlight the entry in the formula bar and hit CTRL-C, then go into the cell you want to attach it on to, go into the formula to the end of the string, then hit CTRL-V, it will paste it onto the end.

You can also do it with a formula, i.e.:
=A1 & B1

 

[Von Pookie]

You can just add the current value to the start of the new value.

Simplistic, untested example:

Dim OrigVal As String, NewVal As String

OrigVal = Range("A1").Value 'This is the destination cell with the original data
NewVal = Range("B1").Value 'This would be the value you want to copy

'Enter the original value and new value in the cell, separated by a space
Range("A1").Value = OrigVal & " " & NewVal

Edit: Appears I was instantly thinking VBA. Heh.