For instance, you can take the city, state and zip values found in three separate columns and merge them into "city, st zzzzz-zzz". This added a comma and spaces to the 3 values.
To use the feature, in most versions of excel:
- Start by positioning the cursor in the cell in which you want to create the new value.
- Find the fx function button to the left of the field display ( usually right above the B,C, or D column header) or click Insert function in the menu.
- Insert function wizard opens.
- Type concatenate and press Go. This should find the function.
- Select it and click ok.
- Another box pops up and this is where you build your string.
- In our example of city, st zip we would click on the cell in the row we are in that contained the city value.
- The city should display to the right.
- Type a comma followed by a space in the second text field.
- A third field should show up.
- Select the state value.
- In the next text box type another space.
- You can play around with adding the comma and spaces on the same line as the cell.
- You can only have one cell reference in each Text line, but you can have multiple other values.
- As you build your string it will display the result of your efforts below in a formula result.
- When you are satisfied, click ok and the formula result will be displayed in the cell.
- You can copy the formula to other cells.