Last week AC-XL shared this function....
Cell S2 =SUBSTITUTE(TRIM(K2&" "&L2&" "&M2&" "&N2&" "&O2&" "&P2&" "&Q2&" "&R2)," ","; ")
…for combining fields without getting extra spaces or semi-colons. It works great. Now I’m wondering if it is possible to add a refinement that would make things even easier.
Before using AC-XL’s function above, I manually insert columns (K thru S) and then manually add this function......
Cell K2 =IF(C2="x",C$1,"")
Cell L2 = =IF(D2="x",D$1,"")
etc.
….which basically copies the Column label into the field if it has an “x” in it. Only then can I use AC-XL’s function.
Any way to combine this all in one function?
Bookmarks