Want to get the Numbers

[niladri20052006]

Hi All,

I have the set of numbers like 123456789123, 345689733848 etc in Column A.
I want to get the numbers except the first 10 digits.

the numbers are not same the same digit. sometimes it is 14 and some times it is 12.

So I want the last 4 or 2 digits. I do not apply the "Text to Column" option.

Is there any formula to do that?

 

[VoG]

Try

=RIGHT(A1,LEN(A1)-10)+0

 

[thewoodington]

=right(A1,4) would give you the last 4 digits
=right(A1,2) would give you the last 2 digits

=left gives you the first digits in the cell

 

[JazzSP8]

Hi

Perhaps this would work?

=VALUE(LEFT(A1,LEN(A1)-10))

HTH

 

[pgc01]

For ex., for

12345123450123

You want the result as a number

123

or as text

0123

?

So I want the last 4 or 2 digits. I do not apply the "Text to Column" option.

Why not? Seems the easiest solution.