ExcelBanter - delete a number within larger number in a cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - delete a number within larger number in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/74380-delete-number-within-larger-number-cell.html)

John1023

delete a number within larger number in a cell?

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

delete a number within larger number in a cell?

=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.

John1023

delete a number within larger number in a cell?

i can't get this to work.

"Sloth" wrote:

=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.

JE McGimpsey

delete a number within larger number in a cell?

What does that mean?

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

In article ,
"John1023" wrote:

i can't get this to work.

All times are GMT +1. The time now is 10:57 PM.