Replace Comma's with Dash

[brettmanning24]

Hello,

Please could someone help me. In cell A1 of my spreadsheet I have
"ABC,DEF,GHI". I would like B1 to contain the same data as A1 but
with a dash instead of a comma i.e. ABC-DEF-GHI. The number of
comma's will never be the same so all comma's need to be replaced. I
need to use a formula otherwise I would have used find and replace.

Can anyone help.

=REPLACE(A1,FIND(",",A1,1),1,"-")

I used this but it only replaces the first comma, I need to find out
how many comma's there are in A1.

Thanks,

Brett

 

[yshridhar]

you can use replace command (Ctrl-H).
best wishes
sreedhar

 

[Rick Rothstein \(MVP - VB\)]

Try this instead...

=SUBSTITUTE(A1,",","-")

Rick