Tuesday, December 8, 2009

How do I combine two cells in Excel?

Sometimes you may want to combine into one column text that is currently contained in two columns. One way to do this is to write a formula in a third column which uses the concatenation operator, the ampersand (&). This formula in cell C1 would return the contents of A1 followed by the contents of B1:

=A1&B1

If you want to include a literal character, say a space, use the form:

=A1&" "&B1