Breaking numbers and text

[Jomu]

Hi everybody. I got a worksheet with multiple numbers and text like 123456789 and and iebibbfdddfr. I want to leave just 5 numbers from the end, like 56789 or dddfr and so on. How it could be possible ? Is there some code for that ? Please show me 2 codes. 1. When all numbers and text are in the column A. 2. When all numbers and text are in different columns.

 

[Akashwani]

Hi,

This will give you 5 numbers/letters from the last number/letter.

=Right(A2,5)

This is assuming that the cell with the numbers/letters is in A2.

Good luck

 

[Jomu]

Thank You very much for Your kind helpness . I appreciate that very much.