This is an example ofconcatenation.
The article below discusses all three approaches.
Note: Formulas that use concatenation in Excel are quite common, so it is a skill worth knowing.
For a more detailed explanation of concatenation seeHow to concatenate in Excel.
TEXTJOIN will join all three values together separated by a single space (" “).
Note: newer versions of Excel also offer theCONCAT function(which replaces the CONCATENATE function in functionality).
This is often the technique used by more advanced users because it is simple and flexible.
We begin with the first name in B5 and end with the last name in cell D5.
If C5 is empty, return an empty string ("").
However, do not enclose the ampersand (&) or cell references in quotes.
CONCATENATE solution
Another way to solve this problem is with the olderCONCATENATE function.
In Excel 2019 and later, theCONCATandTEXTJOINfunctions are better, more flexible alternatives…
