Simple Replacement

[excelnow]

Hi,

I have a macro and at one part of it I need it to do the following:

Input

Column C

word word word
word word
word word word word
word word
...

Output

Column F

word-word-word
word-word
word-word-word-word
word-word
...

As you see, I want to replace the spaces, " ", with "-". Thanks in advance.

 

[wigi]

For instance:

Columns(3).Replace " ", ""

 

[cmmadn]

you probably don't actually need a macro, you could use excel's find/replace inbuilt function

ctrl+h

 

[wigi]

you probably don't actually need a macro

I have a macro and at one part of it ...