Concatenate in excel?

Answer:
Concatenate means to join text together. You can do this using the & operator. So say you have a firstname of a person in cell B2 and their surname in cell C2 and in D2 you want to display their first name, a space and their surname together, you would do this:

=B2&" "&C2
First answer by Flukey. Last edit by Flukey. Contributor trust: 713 [recommend contributor recommended]. Question popularity: 1 [recommend question].