=0&SUBSTITUTE(SUBSTITUTE(Outward!B5,"-","",1),"-",0,1)

--

Vasant


"Steved" wrote in message
...


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.