Quote:
Originally Posted by mbenton
Sometimes in engineering and surveying, distances along a line or curve from a beginning point are expressed as station numbers. For example, the first point could be 50.50 feet from the beginning point and would be expressed as 0+50.50, the next point might be 136.68 feet from the beginning point and would be expressed as 1+36.68 and the next point might be 243.89 feet from the beginning point and would be expressed as 2+43.89. Can someone show me how I can get excel to add or subtract these station numbers?
Thanks in advance for your help.
|
I'm not sure I understand how this works. Does the number to the left of the plus sign always correspond to the hundreds portion of the distance?
If so, you can convert such numbers with the following:
=LEFT(A1,FIND("+",A1)-1)*100+RIGHT(A1,LEN(A1)-FIND("+",A1))