How to remove hyphen (dash)

[mljohn]

In column E I have this formula
=IF(G16="","", IF(COUNTIF(G16,"*Canon*"),TRIM(LEFT(SUBSTITUTE(MID(G16,FIND(" ",SUBSTITUTE(G16," "," ",3))+1, LEN(G16))," ",REPT(" ",LEN(G16))),LEN(G16))), "False"))

In Column G I have this text
Canon GPR-53C Compatible Cyan Toner Cartridge

The formula returns this:
GPR-53C

I want to return this with no dash:
GPR53C

I used this formula to remove the dash and get "GPR53C"
=SUBSTITUTE(E16,"-","")
but I don't know how to merge the upper formula and lower formula to remove the dashes.

Can you help?

 

[gaz_chops]

maybe

=IF(G16="","", IF(COUNTIF(G16,"*Canon*"),substitute(TRIM(LEFT(SUBSTITUTE(MID(G16,FIND(" ",SUBSTITUTE(G16," "," ",3))+1, LEN(G16))," ",REPT(" ",LEN(G16))),LEN(G16))),"-",""), "False"))

 

[mljohn]

maybe

=IF(G16="","", IF(COUNTIF(G16,"*Canon*"),substitute(TRIM(LEFT(SUBSTITUTE(MID(G16,FIND(" ",SUBSTITUTE(G16," "," ",3))+1, LEN(G16))," ",REPT(" ",LEN(G16))),LEN(G16))),"-",""), "False"))

This worked. Thanks

 

[gaz_chops]

You're welcome.