Replace Comma with Dash

  • Thread starter Thread starter brettmanning24
  • Start date Start date
B

brettmanning24

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
 
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
 
Check out Rick Rothstein's reply in your other post.

His answer works as I have tried it myself.

Mark.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace Comma's with Dash 2
Counting the number of times a character occurs in a cell 1
Replace Comma with "-" 2
Replace Comma with "-". 1
Replace Comma with Hyphen 2
Count based on string in cell 2
Formula (or code) return the largest number of duplicates in a list. 16
Splitting data from cells into multiple lines 6

Back
Top