Replace Comma with Dash
 

Hello,

Please can someone explain how I can replace commas with a dash/
hyphen. For example cell A1 contains "ABC,DEF,GHI". I would like
cell B1 to display "ABC-DEF-GHI".

I attempted to use REPLACE(A1,FIND(CHAR",",A1),1,",") but this only
replaces the first comma.

I need to cound how many comma's are in the text and then replace
them. I know I could you a find and replace but I need a formula.
The number of commas in the text will vary. Sometimes there are 2
other times there are none.

Thanks,
Brett

Replace Comma with Dash
 

Try,

Edit|Replace

Replace what ,
Replace with -

You now have a choice depending on the construction of your worksheet. You
can do a replace all but this will do precisely that even for commas you may
not want it to or you can step through with Find.

Mike

" wrote:

Hello,

Please can someone explain how I can replace commas with a dash/
hyphen. For example cell A1 contains "ABC,DEF,GHI". I would like
cell B1 to display "ABC-DEF-GHI".

I attempted to use REPLACE(A1,FIND(CHAR",",A1),1,",") but this only
replaces the first comma.

I need to cound how many comma's are in the text and then replace
them. I know I could you a find and replace but I need a formula.
The number of commas in the text will vary. Sometimes there are 2
other times there are none.

Thanks,
Brett

Replace Comma with Dash
 

Check out Rick Rothstein's reply in your other post.

His answer works as I have tried it myself.

Mark.

Replace Comma with Dash
 

Was something wrong with the answer I gave you (in your first posting) some
48 minutes before you posted this same question over again?

Rick


wrote in message
...
Hello,

Please can someone explain how I can replace commas with a dash/
hyphen. For example cell A1 contains "ABC,DEF,GHI". I would like
cell B1 to display "ABC-DEF-GHI".

I attempted to use REPLACE(A1,FIND(CHAR",",A1),1,",") but this only
replaces the first comma.

I need to cound how many comma's are in the text and then replace
them. I know I could you a find and replace but I need a formula.
The number of commas in the text will vary. Sometimes there are 2
other times there are none.

Thanks,
Brett