Last 4

[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

 

[Pete_UK]

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

 

[Dave Peterson]

=right(a1,4)
will return text

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

=mod(a1,10000)
will also return a number

 

[Hendrix]

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 -

It worked

Thanks

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete