Remove character from middle of cell value

[jblyx002]

I need to remove the plus (+) from the middle of a number. I was going to create a Column C to extract the plus out of the text in B, so that I can sort the spreadsheet to be in station order. Could someone please help. Yes, I know I can copy it over a column then find & replace in that column but what about an automated thing.

Station (column B)	Station for sorting (column C)
1+00.00	100.00
5+46.75	546.75
10+17.15	1017.15
20+00.00	2000.00
21+45.92	2145.92
22+77.10	2277.10
23+96.55	2396.55

<tbody>
</tbody>

 

[VoG]

Try in C2 copied down

=SUBSTITUTE(B2,"+","")+0

 

[jblyx002]

Thanks for the help