Hi,

Try this:
=SUBSTITUTE(A1,"-","")
assumed that your string is in the cell A1.

Thanks,

--
Farhad Hodjat


" wrote:

I have the following data in a cell 00000-0000-00 and I want to format
the cell to remove the dashes, 00000000000. How would I do that?

Thanks so much!