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)
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.