Last 4

  • Thread starter Thread starter Hendrix
  • Start date Start date
H

Hendrix

I have a field that is made up of 7 numbers and I want to create a new
field of just the last 4. Can someone help me with this?


ie...original field 1234567 new field 4567
 
You can do this:

=RIGHT(A1,4)

if you are happy with text values. If you require a number, then do
this:

=--RIGHT(A1,4)

Hope this helps.

Pete
 
=right(a1,4)
will return text

=--right(a1,4)
will return a number

=mod(a1,10000)
will also return a number
 
You can do this:

=RIGHT(A1,4)

if you are happy with text values. If you require a number, then do
this:

=--RIGHT(A1,4)

Hope this helps.

Pete




- Show quoted text -
Click to expand...

It worked

Thanks
 
Back
Top