topic Split Long String Label into Multiple fields by length in Esri Certified Individuals Questions https://community.esri.com/t5/esri-certified-individuals-questions/split-long-string-label-into-multiple-fields-by/m-p/832520#M52 <HTML><HEAD></HEAD><BODY><P>I'm trying to label a field "MaxGrantee" that has some rather long named entries that are going outside of their polygon and overlapping other labels. &nbsp;I have read other posts and have found this expression: &nbsp;<STRONG>left([MaxGrantee] ,InStr(20, [MaxGrantee] ," ")) &amp; vbnewline &amp; right( [MaxGrantee] ,len( [MaxGrantee] )-(InStr(20, [MaxGrantee] ," ")))</STRONG></P><P>But it will not work. &nbsp;All is get is an error saying: &nbsp;<EM>Error 1 on Line 2. &nbsp;Invalid use of Null: 'InStr(...)'.</EM></P><P>Does anyone have an ideas of what I'm doing wrong?</P><P>I'm in 10.2.2 version 3552</P><P>I'm labeling from a personal GDB. &nbsp; Thanks##</P></BODY></HTML> Tue, 24 Jan 2017 16:08:37 GMT NicholasGoodwin 2017-01-24T16:08:37Z Split Long String Label into Multiple fields by length https://community.esri.com/t5/esri-certified-individuals-questions/split-long-string-label-into-multiple-fields-by/m-p/832520#M52 <HTML><HEAD></HEAD><BODY><P>I'm trying to label a field "MaxGrantee" that has some rather long named entries that are going outside of their polygon and overlapping other labels. &nbsp;I have read other posts and have found this expression: &nbsp;<STRONG>left([MaxGrantee] ,InStr(20, [MaxGrantee] ," ")) &amp; vbnewline &amp; right( [MaxGrantee] ,len( [MaxGrantee] )-(InStr(20, [MaxGrantee] ," ")))</STRONG></P><P>But it will not work. &nbsp;All is get is an error saying: &nbsp;<EM>Error 1 on Line 2. &nbsp;Invalid use of Null: 'InStr(...)'.</EM></P><P>Does anyone have an ideas of what I'm doing wrong?</P><P>I'm in 10.2.2 version 3552</P><P>I'm labeling from a personal GDB. &nbsp; Thanks##</P></BODY></HTML> Tue, 24 Jan 2017 16:08:37 GMT https://community.esri.com/t5/esri-certified-individuals-questions/split-long-string-label-into-multiple-fields-by/m-p/832520#M52 NicholasGoodwin 2017-01-24T16:08:37Z