Using concatenate and decode in excel

Question

I have a column having values as

A
1.decode(D01,1,1,3,3,4)
2.decode (d02,1,1,3,3,4)
3.decode(d03,1,1,3,3,4)
...
...
31.decode(d31,1,1,3,3,4)

and i need to have these columns in a string seperated by comma as

decode(D01,1,1,3,3,4), decode (d02,1,1,3,3,4), decode(d03,1,1,3,3,4)

and so forth up to 31 such values in a comma separated list.

How will I be able to do this in excel?

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. It sounds like the values in your Column A are exactly what you want? Read your own question:) — , Sep 13 '13 at 09:38

score 1 · Accepted Answer · edited May 23 '17 at 12:13

1

You can do a CONCATENATE over all the rows like:

=CONCATENATE(A1&", "&A2&", "&A3&", "&A4&", "&A5&", "&A6&", "&A7&", "&A8&", "&A9&", "&A10&", "&A11&", "&A12&", "&A13&", "&A14&", "&A15&", "&A16&", "&A17&", "&A18&", "&A19&", "&A20&", "&A21&", "&A22&", "&A23&", "&A24&", "&A25&", "&A26&", "&A27&", "&A28&", "&A29&", "&A30&", "&A31)

Or You can create and use something like the ConcatenateRange presented in this answer

Or You can do:

Set cell B1 to "=A1"
Set cell B2 to "=B1&", "&A2"
Copy cell B2 all the way down to B31

Cell B31 will now contain the concatenated text string you are looking for. enter image description here

edited May 23 '17 at 12:13

Community

1
1

answered Sep 13 '13 at 09:39

manimatters

424
3
11

I know of concatenate and one by one input of arguments list . but this is something i was trying not to do . – HalfWebDev Sep 13 '13 at 09:50
Then try the alternative I suggested – manimatters Sep 13 '13 at 09:51
@manimatters the link to the answer you provided answers the OP's question. +1 – Sep 13 '13 at 09:54
I have added a third alternative – manimatters Sep 13 '13 at 10:08

Using concatenate and decode in excel

1 Answers1