Log In
Register
Home
Active Member
October 23, 2015
Offline
Hi:
I frequently need to copy data containing text from a range of cells, for example A11:F15, and paste it into a single cell.
My current method is:
Select the range of cells
Cntl-C
Open Notepad
Cntl-V
backspace
Cntl-A
Cntl-C
Double click on target cell
Cntl-V
Is there a simpler way?
Thanks,
Dan
Active Member
August 25, 2016
Offline
Hi Dan,
You could try the CONCATENATE formula, or use the "&" function.
=CONCATENATE(A11,A12,A13,B11,B12,B13)
=A11&A12&A13&B11&B12&B13
Ben.
VIP
Trusted Members
June 25, 2016
Offline
Hi Dan
1) Copy the data
2) Open the clipboard
3) Select the cell to paste and press F2 (or double click the cell)
4) From the clipboard paste the copied text
Hope this helps.
Sunny
Active Member
October 23, 2015
Offline
The key is I am copying the data from a range of cells into a single cell in another spreadsheet -- it is not just a copy paste situation.
Please see Copy Source and Copy Target attachment images.
VIP
Trusted Members
June 25, 2016
Offline
Hi Dan
Did you try what I suggested?
I makes no difference whether the data comes from another workbook.
It will give you exactly the same result like what you are currently doing i.e manually copying to notepad and then pasting into Excel.
1 Guest(s)
