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!

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!

Select the data, then:
<Edit <Replace

In "Find What", enter the dash ( - )
Leave "Replace With" empty,
And click on <Replace All.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
ps.com...
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!

On May 15, 5:11 pm, Farhad wrote:
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!- Hide quoted text -

- Show quoted text -

Thank You! Your solution worked perfectly!