Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entire column to comma delimited cell
I have a column of data A1:A156
I want to take each value and place in C1 Where C1 would look like: A1&", "&A2&", "&A3&", "&A4 ....etc I assume I will need a macro to accomplish this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
entire column to comma delimited cell
One way to do this is to
enter =A1 in B1 enter =B1&", "&A2 in B2 copy down till B156 enter =B in C1 B can be any unused column in your spreadsheet and may be hidden later or you can do paste special in C1 the value in B156 and delete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
entire column to comma delimited cell
I would have never thought to do it that way, but works great.
Thanks for the tip. "Sheeloo" wrote: One way to do this is to enter =A1 in B1 enter =B1&", "&A2 in B2 copy down till B156 enter =B in C1 B can be any unused column in your spreadsheet and may be hidden later or you can do paste special in C1 the value in B156 and delete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving as tab delimited or comma delimited | Excel Discussion (Misc queries) | |||
Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
Totaling the number of comma delimited numbers in a column | Excel Worksheet Functions | |||
Import Comma delimited info in a Column | Excel Worksheet Functions | |||
how do I get data from an array into one cell (comma delimited) | Excel Discussion (Misc queries) |