How do you do a cocatenation?

Hi Chloe

Thankyou for your question

Cocatenation is a function that can be used to join a text string or variable to another text string or variable.

For example if you had a person's first name in cell A1 and their surname in cell A2 and you wanted to create a formula that would join the two together, with a space in between; then in the required cell you would type the following.

A1&" "&A2

The & symbol is the cocatenation function and in this instance joins the contents of A1 to a white space and then joins that to the contents of cell A2

Hope this helps

Regards

Stephen