Formatting a cell - remove a dash

[Shawna]

Hello and please help. I need to know how to change the following number in
my cell from 1234-5678 to read as 12345678. Basically I want to remove the -
from my number. I have over 14000 lines and each number in the column needs
to have the dash remove from the number. Thanks

 

[Jim Thomlinson]

First question... Is it a format is is there an acutal dash in the cell
value. If it is a format then just switching the number format to genreal
will remove the dash. If there is an actual dash character then try using
Find and Replace.

 

[T. Valko]

Select the range of cells in question
Goto the menu Edit>Replace
Find what: -
Replace with: nothing, leave this empty
Replace All

 

[Liz J]

Shawna,

I'd go into the Find and replace menu. (Key strokes: Ctrl+f). In the
replace tab, in the "Find what:" data field, type in "-" (without the "", of
course). In the "Replace with:" data field, don't type in anything - leave it
blank. Then, select "Replace All."

If this somehow doesn't work, hit Ctrl+z to undo what you just did.

Hope this helps!

 

[Shawna]

Tried the find replace function....not letting me do it

 

[YESHWANT]

Tried the find replace function....not letting me do it

what error or msg does it shows when u try the same ??