And to beat that dead horse a little harder...

If using English units, here's the equation to convert lengths to fully utilizable values. Of course, B2 is where a given length or coordinate resides.

=IF(ISERROR(FIND(" ft.",B2)),NUMBERVALUE(LEFT(B2,LEN(B2)-3)),IF(ISERROR(FIND("in",B2)),NUMBERVALUE(LEFT(B2,FIND(" ft.",B2))),(ABS(NUMBERVALUE(LEFT(B2,FIND(" ft.",B2))))+NUMBERVALUE(LEFT(RIGHT(B2,LEN(B2)-FIND(" ft.",B2)-3),LEN(RIGHT(B2,LEN(B2)-FIND(" ft.",B2)-3))-3))/12)*NUMBERVALUE(LEFT(B2,FIND(" ft.",B2)))/ABS(NUMBERVALUE(LEFT(B2,FIND(" ft.",B2))))))

I'm going to rib the COADE folks about this one a little bit. CAESAR has an error in the code somewhere such that Y coordinates chops off the period at the end of "in." This started sometime between 2014 and 2017 releases.

I'm not certain of an easier or faster way to get useful lengths out of CAESAR's input editor into Excel.


Edited by Michael_Fletcher (12/13/18 04:12 PM)