Knowledge Base - Technical Articles

Technical Article   HowTo:  Use ArcMap to concatenate fields in a table

Article ID: 22606
Software:  ArcGIS - ArcEditor 8.3, 8.1, 8.1.2, 8.2, 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcInfo 8.2, 9.0, 8.1, 8.1.2, 8.3, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcView 8.3, 8.1, 8.1.2, 8.2, 9.0, 9.1, 9.2, 9.3, 9.3.1
Platforms:  Windows 98, NT 4.0, 2000, ME, XP


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


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

     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:

    [Field Name] & " " & [Field Name] & " " & [Field Name]

     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.

Created: 5/30/2002
Last Modified: 5/19/2011

Article Rating: (3)
If you would like to post a comment, please login


By jplunkett1 - 10/29/2014 8:05 PM

The article needs to be updated.

Hi Esri, This is a good article for reference, however this also works on ArcMap 10.2.2 as well.


By lamalfred - 05/18/2011 9:15 PM

The article needs to be updated.

good, you can repeat the codes on the same field.


By Anonymous - 10/27/2009 10:13 AM

The article has missing, misleading, or conflicting information.

In step #8, shouldn't it read "Field Calculator"?