This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Combine Strings Together

Microsoft Excel 2003 spreadsheets that include names, addresses, and other text often require the results of two or more cells combined together, or concatenated.

For example, an address spreadsheet for the United States may be divided into several fields such as each person's name, street address, city, state, and zip code. For printing purposes, it may be useful to include in another field the combined address elements together.

Here are two ways to combine strings together:

=concatenate(VALUE1,VALUE2,...VALUE_N)

VALUE1, VALUE2, .. VALUE_N is a set of values (up to 30) to be combined together

OR:

& operator in the form =VALUE1 & VALUE2

VALUE1 and VALUE2 are two text values to be combined together

For example, assume the following spreadsheet contains names divided by first and last. The final two rows combine the name parts together, separated by a space.


A B
1 First Name Last Name
2 John Smith
3 Susan Barnes
4
5 Name 1: =A2 & " " & B2
6 Name 2: =CONCATENATE(A3," ",B3)

The results:

B5: John Smith
B6: Susan Barnes



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Combine Strings Together.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.