For example, you might link cells A2 and B2 together using
=A2 &" " &B2The ampersands (the & thingie) do the linking. The " " just adds a space between the two cell contents. If A2 and B2 had forename and surname in then that might produce a more useful cell to use.
There's an example of how to use concatenation to produce a cool and funky order number at That Blue Square Thing. Check it out, it's cool and funky and there are no chickens to be seen.
Hannah says concatenation is cool.
e2a: I've not thrown the macro code in as a screenshot as well. Just because I'm feeling kind.