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


"John1023" wrote:

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.