In cell E$2,$ enter a formula using TEXTJOIN to combine the text from cells B$2$:D$2$ into a single text string. Use the # character as the delimiter. ignore blank cells. use a cell range as the Text$1$ argument.