Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I copy a number of cells in a column to a single cell ina row
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I copy a number of cells in a column to a single cell ina row
You can use a formula like:
=a1&b1&c1&d1&.... or =a1&" "&b1&" "&c1&" "&d1&... or =a1&char(10)&b1&char(10)&... (to wraptext if the cell is formatted nicely) If you have to do this for lots of cells, you may want to use this function from JE McGimpsey: http://www.mcgimpsey.com/excel/udfs/multicat.html If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) 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 |
#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 |
Reply |
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) |