| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get data from an array into one cell (comma delimited)
looking for a way to query an array 3 cells by 3 cells (they have numeric
data only) and return a value in a seperate cell that has all the numbers in the array (comma delimited) thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get data from an array into one cell (comma delimited)
If C1 thru E3 contain:
1 2 3 4 5 6 7 8 9 then: =C1 & "," & D1 &","& E1 &","& C2 &","& D2 &","& E2 &","& C3 &","& D3 &","& E3 will return: 1,2,3,4,5,6,7,8,9 -- Gary's Student "bb" wrote: looking for a way to query an array 3 cells by 3 cells (they have numeric data only) and return a value in a seperate cell that has all the numbers in the array (comma delimited) thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forcing data into a cell | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Vlookup for data contained in a cell | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
