HELP Complex Excel Formula

[vasiliskyj]

0040000054546
5
0040000095454
9
0040000089651
4
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?

<tbody>
</tbody>

 

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