delete a number within larger number in a cell?

John1023 · Feb 28, 2006

how do you delete a number within larger number in a cell for several rows?
for example i want to delete the 0 in the 7th position of 025000000.

Sloth · Feb 28, 2006

=LEFT(A1,6)&RIGHT(A1,2)

John1023 · Feb 28, 2006

i can't get this to work.

Sloth said:
=LEFT(A1,6)&RIGHT(A1,2)

JE McGimpsey · Feb 28, 2006

What does that mean?

Do you get an error? a crash? an incorrect result? no result?