Replace Comma with "-".

B

brettmanning24

Hello,

I would like to replace commas with a hyphen/dash. For example cell
A1 contains "ABC,DEF,GHI", I would like to replace the "," with "-"
i.e. "ABC,DEF,GHI".

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

I need to find out how many "," are in the text and replace them all.
I know I could use find and replace but I need to use a formula.

Thanks in advance,

Brett
 

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 with "-" 2
Replace Comma with Hyphen 2
Replace Comma with Dash 3
Replace Comma's with Dash 2
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1
Lookup value in table with multiple results 3
Count based on string in cell 2
Help with IF 3

Top