Merging numbers in a column separated by coma using CONCATENATE

**euphoric.jag** · 05-22-2013, 08:56 AM

Can we merge numbers in a column separated by coma using CONCATENATE formula?

**Ron Coderre** · 05-22-2013, 09:04 AM

Originally Posted by euphoric.jag

Can we merge numbers in a column separated by coma using CONCATENATE formula?

Can you post an example of what you want to do?
...Sample data and the results you want to calculate (based on the sample data)

**sinha.riteshabap** · 05-22-2013, 09:07 AM

try it,

=CONCATENATE(A1&","&B1)

**euphoric.jag** · 05-23-2013, 04:12 AM

Sir,
I have attached data. Kindly have a look.

**Ron Coderre** · 05-23-2013, 09:12 AM

Excel does a poor job of concatenating a series of cells.
However, if you're looking for a shortcut (sort of)...Try this:

Using your posted workbook
E2: =IF(A2="","",IF(ISNUMBER(A1),E1&B2&A2,A2))
Copy that formula down through E38

The result you want will be in E32 and E38

Is that something you can work with?