H
Hendrix
I have a field with 9 numbers and I would like to extract the last 5.
(ie 123456789 to 56789) Is that possible?
(ie 123456789 to 56789) Is that possible?
P
Pete_UK
Try this:
=RIGHT(A1,5)
or, if you need it as a number:
=RIGHT(A1,5)*1
Hope this helps.
Pete
=RIGHT(A1,5)
or, if you need it as a number:
=RIGHT(A1,5)*1
Hope this helps.
Pete
R
Rick Rothstein
Another way...
=MOD(A1,100000)
=MOD(A1,100000)
H
Hendrix
Thanks
P
Paresh Patel
=RIGHT(A1,5)
this is one solution provided the number is in A1 reference.
this is one solution provided the number is in A1 reference.
B
Bernd P
.... Pray its positive
Regards,
Bernd
R
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)
Okay, if there could be negative numbers...
=MOD(ABS(A1),100000)