English

How To: Use ArcMap to concatenate fields in a table

Summary

Instructions provided describe the necessary steps to concatenate values from two or more fields in a table using ArcMap.

Procedure

  1. Start ArcMap
  2. Add a dataset or stand alone table to ArcMap.
  3. Right-click the layer or table in the Table of Contents.
  4. Select the 'Open Attribute Table' or 'Open' option, depending on the data source.
  5. Select 'Options > Add Field.'

    Note:
    It is possible to use an existing field, but the output of this process will overwrite existing data in that field.

  6. Define the new field in the 'Add Field' dialog box and click OK.
  7. Right-click the field name of the new field.
  8. Select 'Field Calculator.'
  9. Click 'Yes' to the following prompt:
    [O-Image] Calculate values

  10. Type the following expression, where [Field Name] is the name of each individual field to be concatenated:

    Code:
    [Field Name] & " " & [Field Name] & " " & [Field Name]

    Note:
    This expression adds a space between the values that are being concatenated. For further information on the use of the concatenation operator, see the Microsoft Visual Basic Editor Help files. In ArcMap, select Tools > Macros > Visual Basic Editor. In the Visual Basic Editor, click Help > Microsoft Visual Basic Help. Click the Index tab, type "concatenation operators", and click 'display.' Select '& operator' and click 'display.'

  11. Click OK.