You can use a UDF (User defined function) which uses VBA (Visual basic for Applications). Here's one by Tigeravatar.
How to enter it
1. Copy the code, In your workbook, hit ALT F11 (to open vba editor)
2. Insert> Module in the editor
3. Paste the code into the white text box.
4. Close the editor
How to use it
1. Has the format = ConcatAll(range, delimiter) for example = ConcatAll(B2:F2, ", ")
2. Macros need to be enabled for it to work. Sheet must be saved as an xls or an xlsm workbook
Questions?
Bookmarks