Using formula below to strip alpha & numeric characters from right side of
character string in ColB. When copying formula to underlying cells, row
reference changes as expected but formula result does not reflect the new row
until I either double click to reset the formula, or click of insert function
button and hit return. This formula worked one week ago. No known changes
to Excel. Other users report similar strange behavior. Tried "detect and
repair" to fix but no effect. Please help if you have any insight to this.
=IF(ISERROR(1*((IF(ISERROR((1*(LEFT(((RIGHT((TRIM( $B2)),4))),1)))),0,(1*(LEFT(((RIGHT((TRIM($B2)),4) )),1)))))&(1*(RIGHT(((RIGHT((TRIM($B2)),4))),3)))) ),"N/A",1*((IF(ISERROR((1*(LEFT(((RIGHT((TRIM($B2)),4)) ),1)))),0,(1*(LEFT(((RIGHT((TRIM($B2)),4))),1))))) &(1*(RIGHT(((RIGHT((TRIM($B2)),4))),3)))))