https://community.esri.com/t5/arcgis-pro-questions/formatting-excel-column-to-match-a-text-field-with/m-p/1111556#M47227 <P>If formatting the text field in excel to a specified cell width loses its specification, then it is probably isn't honored or an issue.</P><P>You can only alter field widths when the field contains no data at all.</P><P>If the two fields are participating in a join (eg. table to featureclass table) then the featureclass table properties will take precedence).</P><P>If the field width is a real issue, then add a new field in the point featureclass table of the desired width and copy (via the field calculator) the table values into the new field.</P><P>Since the 255 character is not causing a "issue" in the sense of interfering with calculations or performance it would probably fall into the "nice" to fix category but not a "need" to fix category</P> Wed, 27 Oct 2021 09:38:10 GMT DanPatterson 2021-10-27T09:38:10Z https://community.esri.com/t5/arcgis-pro-questions/formatting-excel-column-to-match-a-text-field-with/m-p/1111510#M47217 <P>I want to create a relationship and join between a point featureclass&nbsp; and a table generated from Excel.&nbsp; The join field in GIS is Text Field of 30 length.</P><P>The excel table imports as a table to have a length of 255.&nbsp; Ideally I wouldn't have to change it manually, but when I tried it wouldn't let me do it anyway.</P><P>Is there a way to either format the Excel table, or force the join field to be the length to match the Featureclass.&nbsp; I cant change the Featureclass field as it is used in many other situations.</P> Wed, 27 Oct 2021 04:10:06 GMT https://community.esri.com/t5/arcgis-pro-questions/formatting-excel-column-to-match-a-text-field-with/m-p/1111510#M47217 BrianOberdorf 2021-10-27T04:10:06Z https://community.esri.com/t5/arcgis-pro-questions/formatting-excel-column-to-match-a-text-field-with/m-p/1111556#M47227 <P>If formatting the text field in excel to a specified cell width loses its specification, then it is probably isn't honored or an issue.</P><P>You can only alter field widths when the field contains no data at all.</P><P>If the two fields are participating in a join (eg. table to featureclass table) then the featureclass table properties will take precedence).</P><P>If the field width is a real issue, then add a new field in the point featureclass table of the desired width and copy (via the field calculator) the table values into the new field.</P><P>Since the 255 character is not causing a "issue" in the sense of interfering with calculations or performance it would probably fall into the "nice" to fix category but not a "need" to fix category</P> Wed, 27 Oct 2021 09:38:10 GMT https://community.esri.com/t5/arcgis-pro-questions/formatting-excel-column-to-match-a-text-field-with/m-p/1111556#M47227 DanPatterson 2021-10-27T09:38:10Z