Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() SUBSTITUTE(Outward!B5,"-","0")+0 from 1-100-1 to 0110001 please Ok I was kindly given the above formula Which I am grateful and useful. Please can I Have it so it deletes the first - in 1-100 to be 1100 the end result woud be 0110001 from the original 1-100-1 value in brief first - deleted, the second - replace with a 0. Thankyou for your time on this issue. |