Combining two or more strings and values into one cell by gluing them together is know as concatenation.  In Excel concatenation can be express in two ways:

=CONCATENATE(A1,A2)

OR

=A1&A2

Where the arguments can be upto 30 cells and / or custom strings enclosed by quotes.

Here are some examples of how it can be used:

Read the rest of this entry »