Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to get one column of text to move into another column that already has text. I DON'T want to replace it, I want the transferring text to be added to the already existing text in a shp file attribute table.


permit   acct id
123      567
324      456

I want to take the "acct id" numbers and bring them into the permit column and have it look like this...

share|improve this question
Is this in ArcGIS 9.3 ? – djq Feb 7 '11 at 23:56
yes it is in 9.3 – Zoran Feb 8 '11 at 6:02
up vote 7 down vote accepted

You need to concatenate information from two fields using the & operator (see this link for all supported operators) . You can do this from ArcGIS's Field Calculator using [mycol1] =:

[mycol1] & [mycol2]

If you want a space in between the two values:

[mycol1] & " " & [mycol2]

This only works for text type destination fields. If you want something fancier, then you probably need to do some preprocessing in the "Advanced" mode.

share|improve this answer
I've tried that and I'm recieving the FC box saying "At least one value did not fit into the specificed text field and had to be truncated. truncated values are flagged with a trailing * – Zoran Feb 9 '11 at 17:33
i clicked the column I wanted... FC ... then I clicked the "township" and the "section (column that I need the numbericals to be transferred)" [township] & [section] is what it looks like – Zoran Feb 9 '11 at 17:35
Mike, ok..only in text... what can you do if it is Numerical? – Zoran Feb 14 '11 at 13:23
You can only have numbers (no spaces or string characters) in numeric fields. The rule of thumb I've used is, unless you're going to perform math on the field's values, make it a text field. Note that if you want to convert from text to numeric or vice-versa, you can use VBA functions to do so (just like in Excel) – neuhausr Feb 14 '11 at 15:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.