Formatting a cell - remove a dash

  • Thread starter Thread starter Shawna
  • Start date Start date
S

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
 
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.
 
Select the range of cells in question
Goto the menu Edit>Replace
Find what: -
Replace with: nothing, leave this empty
Replace All
 
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!
 
Tried the find replace function....not letting me do it

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