Adding additional substitute to substitute formula

[pluginguin]

I have a formula that replaces all spaces in a string with a dash "-".
The problem with this is, is that when the original string already contains a dash between spaces " - " the endresult now is "---"
I would like to modify my formula to prevent this from happening and in those cases just remove the spaces.

Example string: "Trampolines - A great way to train your equilibrium"

Current formula:

=SUBSTITUTE(D71," ","-")

Current result: "Trampolines---A-great-way-to-train-your-equilibrium"

Desired result: "Trampolines-A-great-way-to-train-your-equilibrium"
How to modify the formula?

 

[FormR]

Hi, how about:

=SUBSTITUTE(SUBSTITUTE(D71," - ","-")," ","-")

 

[Alex Blakenburg]

How about:

        =SUBSTITUTE(Application.Trim(D71)," ","-")

It will reduce multiple " " to a single " " first.

 

[pluginguin]

How about:

        =SUBSTITUTE(Application.Trim(D71)," ","-")

It will reduce multiple " " to a single " " first.

Hi Alex, this formula didn't do anything for my problem. I don't have multiple spaces... I had a dash between 2 spaces. When the spaces get replaced by a dash I get 3 dashes. FormR's (simple) solution works!

 

[Alex Blakenburg]

Thank you for feedback. Glad that FormR's solution worked for you.