excel courses - What is concatenate and how does it work?

Hi Sean

Thank you for your question.

The Concatenate function is designed to join text strings together, for example, if you had a person's first name in say cell A1 and their last name in cell B1, you could put the Concatenate function into cell C1 to join the first and last name together =concatenate(a1,b1). If you want a space between the words, use =CONCATENATE(A1," ",B1).

I hope this helps.
Amanda