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
 
Hi Bert
try the following formula
=SUBSTITUTE(B1,"+","")-SUBSTITUTE(A1,"+","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove punctuation mark, Split cells & average accross column 4
% Variance 5
Excel functions 0
Drop Downs, Index Match or what? 56
SUMIF Help 4
Baffeling IF statement 7
SUMIF data that falls within a range 3
Electricity Bill Sheet 6

Back
Top