Ok. This works on your sample data.In Field Calculator...1. Change parser to python2. Check Show codeblock3. Paste the code below into Pre-logic script code4. in the name = box, enter losemunitype(!name!)def losemunitype( name): lsttypes = ['County', 'Parish', 'Borough', 'Municipality', 'Census Area', 'City and Borough'] for losetype in lsttypes: if losetype in name: return name.replace(losetype, '') return name