https://community.esri.com/t5/arcmap-questions/adding-character-to-text-field-using-field/m-p/1066158#M2600 <P>ArcMap 10.7.1&nbsp; New to using scripting to help with adjusting formats and require an assist with my syntax. I tried to bring an excel already formatted, but looks like I need to save as DBF4, and this is not available to me.&nbsp; I'm working with APN numbers, and it would be helpful for them to be formatted ###-###-###.&nbsp; They are currently in field PARCEL_APN as #########.&nbsp;&nbsp;</P> Tue, 08 Jun 2021 20:08:23 GMT KWallin 2021-06-08T20:08:23Z https://community.esri.com/t5/arcmap-questions/adding-character-to-text-field-using-field/m-p/1066158#M2600 <P>ArcMap 10.7.1&nbsp; New to using scripting to help with adjusting formats and require an assist with my syntax. I tried to bring an excel already formatted, but looks like I need to save as DBF4, and this is not available to me.&nbsp; I'm working with APN numbers, and it would be helpful for them to be formatted ###-###-###.&nbsp; They are currently in field PARCEL_APN as #########.&nbsp;&nbsp;</P> Tue, 08 Jun 2021 20:08:23 GMT https://community.esri.com/t5/arcmap-questions/adding-character-to-text-field-using-field/m-p/1066158#M2600 KWallin 2021-06-08T20:08:23Z https://community.esri.com/t5/arcmap-questions/adding-character-to-text-field-using-field/m-p/1066180#M2601 <P>use&nbsp;<A href="https://desktop.arcgis.com/en/arcmap/latest/tools/conversion-toolbox/excel-to-table.htm" target="_blank" rel="noopener">Excel To Table (Conversion)—ArcMap | Documentation (arcgis.com)</A></P><P>and see if it comes in properly as a text field.</P><P>If that doesn't work, you may need to do a field calculation in a text field using something similar to</P><P>(replace&nbsp; "a" with he field&nbsp;</P><LI-CODE lang="python">"{}-{}-{}".format(!a![:3], !a![3:6], !a![6:])</LI-CODE> Tue, 08 Jun 2021 21:22:20 GMT https://community.esri.com/t5/arcmap-questions/adding-character-to-text-field-using-field/m-p/1066180#M2601 DanPatterson 2021-06-08T21:22:20Z