Extracting numbers

[Hendrix]

I have a field with 9 numbers and I would like to extract the last 5.
(ie 123456789 to 56789) Is that possible?

 

[Pete_UK]

Try this:

=RIGHT(A1,5)

or, if you need it as a number:

=RIGHT(A1,5)*1

Hope this helps.

Pete

 

[Rick Rothstein]

Another way...

=MOD(A1,100000)

 

[Hendrix]

Another way...

=MOD(A1,100000)

--
Rick (MVP - Excel)






- Show quoted text -

Thanks

 

[Paresh Patel]

=RIGHT(A1,5)
this is one solution provided the number is in A1 reference.

 

[Bernd P]

Another way...

=MOD(A1,100000)

.... Pray its positive

Regards,
Bernd

 

[Rick Rothstein]

Of course it is positive... wasn't that obvious from the example?<g>

Okay, if there could be negative numbers...

=MOD(ABS(A1),100000)