View Single Post
  #1   Report Post  
Steved
 
Posts: n/a
Default SUBSTITUTE(Outward!B5,"-","0")+0



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.