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)

"dyukon" wrote:


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


--
dyukon
------------------------------------------------------------------------
dyukon's Profile: http://www.excelforum.com/member.php...o&userid=30062
View this thread: http://www.excelforum.com/showthread...hreadid=502928