Removing + from cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a road bid where there are stations involved. In the stations there is a + involved
Example

Station 100+50 to 150+65 where 100+50 is in A1 and 150+65 is in B1
The formula would be B1 - A1. I need to remove the + to make it work but I don't neet the + in the answer
The answer should be 5015
Thank you if you could help
Bert
 
Back
Top