How can I separate mixed words in different excel cells from single excel cell?

Answer 1

Suppose the cell A5 contains the word "STOP", a string

and the cell B5 contains the word "SIGN", another string

then the formula =A5 & B5 will contain STOPSIGN

So the lesson is that the ampersand symbol &

is used to put two strings together