Formating a number in a cell

R

RXLPA3

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!
 
G

Guest

Hi,

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

Thanks,
 
R

Ragdyer

Select the data, then:
<Edit> <Replace>

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

RXLPA3

Hi,

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

Thanks,

--
Farhad Hodjat






- Show quoted text -
Click to expand...

Thank You! Your solution worked perfectly!
 

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

Turning a 9 digit string into zip+4 3
Format a number 3
Number formatting 5
Cell format 1
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell 10
custom cell 2
If , Mid or right functions or a combination thereoff. 3
Insert a picture in worksheet 1

Top