We help IT Professionals succeed at work.
Get Started

Change 10,000 to 100+00 in an Excel Spreadsheet

Sean Daly
Sean Daly asked
on
1,451 Views
Last Modified: 2016-09-28
I work in Pipeline Construction and I do QC work. The way that Survey measures the line is for example, 75,880' down the line  is represented as Station 758+80. Is there a way that i can change 758+80 back to 75,880' so that i can add my joint length? I have to track the welds location, but i am only given stations for certain welds. I have all the joint lengths. I want to be able to have it so i can just make it so I can say for instance,
           current weld station # = (previous weld station #) + (previous pipe length in feet).
           current weld station # =  758+80 + 40
           current weld station # =  759+20
Then also show it back to the 758+56 format. Thank you if somebody could help me. I have something upwards of 3,000 welds to track, or i would just do it manually.
Comment
Watch Question
Engineer, retired
Commented:
This problem has been solved!
Unlock 1 Answer and 10 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE