Surveyor on pipeline

[jneeb]

Hello again,
sometime ago I posted a thread looking for the answer to formula. I lost it.
So here goes. I am working for an engineer firm on natural gas pipelines and I use some surveyors for my work. I need a formula that will calculate this.

1000+00 PLUS 880 EQUALS ?
THE PLUS SIGN HAS TO BE IN THE SUM OF THESE TWO NUMBERS AND IT SHOULD READ 1000+00 PLUS 880 EQUALS 1880+00

[Andy Pope]

This is your previous post.
http://www.excelforum.com/excel-gene...ol-within.html

[jneeb]

This is your previous post.
http://www.excelforum.com/excel-gene...ol-within.html

Andy,
Thanks. I had dug around and found the previous post back in April. This forum has helped a lot of people myself included. keep up the good work.
and as always (Go Redsox) there is always next year.

[xld]

=--left(a1,find("+",a1)-1)+b1&mid(a1,find("+",a1),99)