You can use the ampersand operator (&) in MS Excel when you need to join text. In Excel the ampersand operator is known as the concatenation operator.
For instance, the formula =A2&B2 will join the text values shown in the two cells A2 and B2 below.
When using the ampersand operation you may want to include a space between the two items that are combined to improve the appearance. For instance, if the cells contain first name and last name, you may want to have a space between those names.
To include a space between cells, you will follow the & with a space enclosed in quote, such a &” ” shown below.