Remove dash in cell

[dyukon]

How can I remove the dash in the following cell. A1 = 123-456-789 an
need to have the cell A1 as 123456789

 

[Guest]

Use Edit | Replace (Ctrl-H)

In "Find what" type the dash character
In "Replace with" leave it blank

Highlight all the cells (e.g., the row or column you're interested in -- if
a column, make sure you select "Options" and Search "By Columns" instead of
"By Rows") and select "Replace" (or "Replace All" if you're brave)

 

[Guest]

Hi dyukon. Select all the cells with data and go to Edit - Replace and
replace - with nothing. Excel is going to think you now have a 6 digit
number so format the cells as text if that is what you want. HTH

 

[Guest]

ASAP Utilities, a free Excel Add-in available at www.asap-utilities.com has a
standard feature called "Advanced Character Removal" that will do this nicely.

Vaya con Dios,
Chuck, CABGx3