Maliki Hassani
asked on
Excel: concatenate data into 1 cell
Experts,
Can someone show me how to take a range of data and insert it into 1 cell. I would like to have it seperate the words with a comma and a space.. Is this possible?
Please see attached. Data.xlsm
Can someone show me how to take a range of data and insert it into 1 cell. I would like to have it seperate the words with a comma and a space.. Is this possible?
Please see attached. Data.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The easiest way is to copy the cells into a text editor, change the carriage returns to spaces, copy the resulting text, and paste into the desired cell in your workbook.
Kevin
Kevin
First Of all you will have to get the MoreFunc.dll for excel. Here is the link for it
http://download.cnet.com/Morefunc/3000-2077_4-10423159.html
Once you install it, there is a "MCONCAT()" Function . This will help you concatenate a range of cells and you can use your desired separator.
eg : =MCONCAT(A1:A10,",")
Hope this solves your problem.
http://download.cnet.com/Morefunc/3000-2077_4-10423159.html
Once you install it, there is a "MCONCAT()" Function . This will help you concatenate a range of cells and you can use your desired separator.
eg : =MCONCAT(A1:A10,",")
Hope this solves your problem.
Reference for the above:
http://excel.tips.net/Pages/T003062_Concatenating_Ranges_of_Cells.html
Regards,
Kevin