This is a legitimate concern because of the way the merge tool works. Fortunately, once you know the right way to merge ... data within cells using the ampersand operator (&) and a basic formula.

Adding a text to a cell requires the use of the ampersand operator, the CONCAT function, or the LEFT, RIGHT, and LEN functions. Add your text to the beginning of the cell Add text to the end of a ...