I have a table where some rows have 1 or 2 or 3 up to 20 cells, and I need to put those cells all in one cell seperated by a comma
Thank you for your help
I have a table where some rows have 1 or 2 or 3 up to 20 cells, and I need to put those cells all in one cell seperated by a comma
Thank you for your help
Here's a link to a post that discusses something like that:
http://www.excelforum.com/tips-and-t...geravatar.html
You could also search the forum for "ConcRange" (without the quotes) and will find some useful things to do what you are asking.
- Moo
Column A is your data.
copy cell A1 to B1.
then B2 =
Drag to end of your cell.Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks