The result is the text in B5 joined to the text in C5, separated by a space. When you use concatenation in a formula, be sure to enclose literal text in double quotes (""). Do not enclose the ampersand (&) in quotes, unless you want it to appear in the final result.


You can also use the CONCATENATE function to join text like this: The CONCATENATE function keeps things tidy, but the ampersand creates shorter, more flexible formulas.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.