Pasting is annoying me!!

WILFY06

Board Regular
Joined
Oct 13, 2006
Messages
99
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!!
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,318
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
You can just add the current value to the start of the new value.

Simplistic, untested example:

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

Forum statistics

Threads
1,136,700
Messages
5,677,280
Members
419,683
Latest member
MrVBAConfused

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top