Monday, April 23, 2012

Combining Text from Different Cells (Excel or Google Spreadsheets)

Technique 1: Using the & (Ampersand)

The & symbol consolidates text information in the same way as the + symbol adds numbers. The space between quotation marks adds a blank character between the separated texts.

To combine text with the &:

1. In cell A1, enter the text F1.
2. In cell A2, enter the text Get the Most out of Excel!
3. In cell A3, enter the text The Ultimate Excel Tip Help Guide.
4. In cell A5, type the formula:
=A1&" "&A2&" "&A3

Technique 2: Using the Concatenate Formula
The Concatenate formula allows one to combine text from multiple cells into a single cell.

To combine text use the Concatenate formula:
The Concatenate formula is in the Text category in the Insert Function dialog box. To add a blank character between words, press Spacebar in the second and fourth argument box.
Screenshot // Combining Text from Different Cells
Combining Text from Different CellsCombining Text from Different Cells