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
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.
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
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.
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.
Thank you. I blew past your "Open Clipboard" step in your first response.
Yes! That does do the trick.
Thanks again.
Glad to know you got it sorted out
Sunny
