Can OFFSET be added to CONCATENATEMULTIPLE so the range will change accordingly as the formula is copied down the rows?
I am using UDF CONCATENATEMULTIPLE to combine text that in a range of cells to sentences in a single cell.
Using UDF CONCATENATEMULTIPLE to get a range of cells into one single cell.
IF(B2<>1,"",CONCATENATEMULTIPLE(C$2:C$3,""))
Then using SUBSTITUTE to add a carriage return and "*" at the beginning of each sentence.
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($E2,".","."&CHAR(10)&"* ",1),
".","."&CHAR(10)&"* ",2),".","."&CHAR(10)&"* ",3),".","."&CHAR(10)&"* ",4),".","."&CHAR(10)&"* ",5),
".","."&CHAR(10)&"* ",6),".","."&CHAR(10)&"* ",7),".","."&CHAR(10)&"* ",8),".","."&CHAR(10)&"* ",9),".","."&CHAR(10)&"* ",10),
".","."&CHAR(10)&"* ",11))
I am using UDF CONCATENATEMULTIPLE to combine text that in a range of cells to sentences in a single cell.
Using UDF CONCATENATEMULTIPLE to get a range of cells into one single cell.
IF(B2<>1,"",CONCATENATEMULTIPLE(C$2:C$3,""))
Then using SUBSTITUTE to add a carriage return and "*" at the beginning of each sentence.
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($E2,".","."&CHAR(10)&"* ",1),
".","."&CHAR(10)&"* ",2),".","."&CHAR(10)&"* ",3),".","."&CHAR(10)&"* ",4),".","."&CHAR(10)&"* ",5),
".","."&CHAR(10)&"* ",6),".","."&CHAR(10)&"* ",7),".","."&CHAR(10)&"* ",8),".","."&CHAR(10)&"* ",9),".","."&CHAR(10)&"* ",10),
".","."&CHAR(10)&"* ",11))