Does this help?
="030172" & SUBSTITUTE(A1,"-","")