Text trimmer double criteria

I have this on a1

KD - 0286 #1950
KD - 0298 #1550
KD-0299 (188-S3) # 1550

Please give a complete explanation in ONE posting!

I am using the following formula to get

=SUBSTITUTE(SUBSTITUTE(LEFT(A1,SEARCH("#",A1)-1)," ",""),"-0","")

KD286
KD298
KD299(188-S3)

....and ...???

This is the file , some have brackets some not

I want the result without bracket

KD286
KD298
KD299

Try ..

=IFERROR(LEFT(SUBSTITUTE(SUBSTITUTE(LEFT(A1,SEARCH("#",A1)-1)," ",""),"-0",""),FIND("(",SUBSTITUTE(SUBSTITUTE(LEFT(A1,SEARCH("#",A1)-1)," ",""),"-0",""),1)-1),SUBSTITUTE(SUBSTITUTE(LEFT(A1,SEARCH("#",A1)-1)," ",""),"-0",""))

Work beyond fine , wow

Thank you very much

My pleasure!