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

In my attribute tables field I am trying to get rid of the "&" in between names i.e. "John Adams & wife" and want it to say "John Adams and Wife" in all the attributes with "&".

What is the VB for that?

I can't seem to find it in the help page of ArcGIS.

share|improve this question
vba and vbscript are different languages. At 10.0 calculator supports vbscript and python. Before 10.0 it supported VBA and vbscript. – Kirk Kuykendall Sep 28 '11 at 19:23
up vote 13 down vote accepted

Check out the replace function in the calculate field examples. Something like this should do it:

NewString = Replace([comments], "&", "and")
share|improve this answer
Don't forget that doing this outside of an edit session will overwrite without undo. This solution will work right but you should test more complex calculations (on the containing field). – Brad Nesom Dec 8 '10 at 2:37
Thank You, I solved it late last night. I was very close for a while then figured it out. – Zoran Dec 8 '10 at 17:16

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.