how to add dashes between words in a cell

[beesonic]

Hello everyone.

I am new to this forum and not an excel genius at all but I can manage

I have a formula that now looks like this:
2XU Super Elite Endurance Trisuit 2011-2X1769

And I want it to look like this:
2XU-Super-Elite-Endurance-Trisuit-2011-2X1769

Is there a formula I can use to add dashes between the words in the same cell?

Thanks

[beesonic]

Never mind... i just thought of it... "find & replace".... can you say duh? thanks anyway.

[davesexcel]

Hello,
Not sure what you are talking about, what you have displayed is not a formula, I can only asume you are trying to cocatenate a bunch of cells into one cell.

Try,

=a1&"-"&b1&"-"&c1&"-"d1

[6StringJazzer]

=SUBSTITUTE(formula," ","-")

where

formula

is whatever formula you have now to produce your current results.

[Marcol]

As a matter of interest

Try this in a spare column say B2 with 2XU Super Elite Endurance Trisuit 2011-2X1769 in A2

=SUBSTITUTE(A2," ","-")

Drag/Fill Down

Of course if Find/Replace does the job use it!

[naughtyboytoyz]

did anyone figure out how to do this. I need to put dashes between the words; instead of spaces.

[6StringJazzer]

did anyone figure out how to do this. I need to put dashes between the words; instead of spaces.

Yes, see the posts above for the answers.

[gmohanprasad1]

=SUBSTITUTE(formula," ","-")

where

formula

is whatever formula you have now to produce your current results.

WOW thanks for this simple formula.