HELP Complex Excel Formula

[vasiliskyj]

[TABLE="width: 500"]
<tbody>[TR]
[TD]0040000054546[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0040000095454[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0040000089651[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I want to make 6 number places delete the first 7 numbers so for ex: 89651 and I would like to move the number 4 from one cell right above so final product 896514. Any formulas for these tasks? [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[NBVC]

Do you mean?

=RIGHT(A1,5)&A2

where A1 contains original, and A2 contains the digit to concatenate to the purged value of A1.

this formula goes in another empty cell.

 

[vasiliskyj]

Do you mean?

=RIGHT(A1,5)&A2

where A1 contains original, and A2 contains the digit to concatenate to the purged value of A1.

this formula goes in another empty cell .

Thank you that's exactly what I needed. How do you apply this formula to 5000 numbers?

 

[NBVC]

=IF(LEN(A1)>5,RIGHT(A1,5)&A2,"")

copied down.