combining 2 substitute formulas

[ericc]

I need to combine these two substitute formulas.

=SUBSTITUTE(B16,"-","")
=SUBSTITUTE(B16," ","")

Basically B16 has an item number in it (example 14-22 R) Sometimes it might not have a "-" and other times it might not have a " ".

I thought it should look like this
=SUBSTITUTE(SUBSTITUTE(B16,"-","")B16," ","") but it gives an error and want to try to multiply them together

what am i doing wrong??

thank you,
Eric

[Paul]

Hi Eric, you were close.

Try:

=SUBSTITUTE(SUBSTITUTE(B16,"-","")," ","")

[ericc]

I got it finally..
=SUBSTITUTE(SUBSTITUTE(B16,"-","")," ","")

It seems to work..

[ericc]

haha.. Thanks Paul.. I didn't see your post until I made the post. I appreciate your help!