| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I copy a number of cells in a column to a single cell ina row
ps. The formula would be for a column:
=a1&a2&a3&.... Bev wrote: I have between 6 and 10 pieces of data which I wish to copy from the column they are in, into a single cell (which has been merged to make it larger and more visible to see) The data which is just a series of numbers or letters (or a combination of both) do not need to be re-used from this merged cell Can you help please? Bev -- Bev -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Copy single Cell into Multiple cells | Excel Worksheet Functions | |||
| I would like to copy UNIQUE data from a column in a SINGLE CELL | Excel Discussion (Misc queries) | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| Copy column of cells to a single cell? | Excel Discussion (Misc queries) | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
