View Single Post
 
Old 12-21-2015, 03:32 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

Change the formulas in columns DM to DP to this:
DM5:
=SUBSTITUTE(TRIM(CONCATENATE(BS5&" "&BW5&" "&CA5&" "&CE5&" "&CI5&" "&CM5&" "&CQ5&" "&CU5))," ",",")
DN5:
=SUBSTITUTE(TRIM(CONCATENATE(BT5&" "&BX5&" "&CB5&" "&CF5&" "&CJ5&" "&CN5&" "&CR5&" "&CV5))," ",",")
DO5:
=SUBSTITUTE(TRIM(CONCATENATE(BU5&" "&BY5&" "&CC5&" "&CG5&" "&CK5&" "&CO5&" "&CS5&" "&CW5))," ",",")
DP5:
=SUBSTITUTE(TRIM(CONCATENATE(BV5&" "&BZ5&" "&CD5&" "&CH5&" "&CL5&" "&CP5&" "&CT5&" "&CX5))," ",",")

and similarly with the formulas in columns BN:BQ, then your formulas in DS and DT will work as they are.

TRIM removes any leading and trailing spaces, and replaces any consecutive spaces within the text with a single space. SUBSTITUTE then replaces those single spaces with commas.
Reply With Quote