Hi - Dave here.
One of the most important skills in Excel formulas is
concatenation.
Concatenation is just a fancy name for joining things together. You can see a basic example in the worksheet below:
There are two basic ways to concatenate in Excel:
1. Manually with the ampersand operator (&)
2. With a function like CONCAT or TEXTJOIN
The article below explains both approaches with many examples.
https://exceljet.net/how-to-concatenate-in-excel
The workbook is attached near the bottom of the article. Have a look and try out concatenation in your own formulas.
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a nice weekend!
Dave
