TRUE, A1:B1). The formula begins with the delimiter to select how the text should be separated, the next step of the formula is ignore_empty, and when TRUE is used empty cells are ignored. The last part of the formula is to specify the cells that should...