deleting numbers in a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

roddtx - 17 Mar 2006 19:54 GMT

:) :) can someone assist with the formula that would allow me to remove

all but the last 4 digits in a column of numbers

Signature

roddtx

Reply to this Message

AndyB - 17 Mar 2006 19:59 GMT

Hi
You could use a helper column with this in:
=RIGHT(A2,4)
and fill this down.

Andy.

> :) :) can someone assist with the formula that would allow me to remove
> all but the last 4 digits in a column of numbers

Reply to this Message

roddtx - 17 Mar 2006 20:30 GMT

you are the best

:) > Hi
> You could use a helper column with this in:
[quoted text clipped - 15 lines]
> > View this thread
> http://www.excelforum.com/showthread.php?threadid=523694

Reply to this Message

Bernard Liengme - 17 Mar 2006 20:04 GMT

Can we assume we are dealing with whole numbers?
=--RIGHT(A1,4)
RIGHT returns text, the double negation turns this back to a number

OR

=MOD(A1,10000)

Then copy either formula down the column.

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> :) :) can someone assist with the formula that would allow me to remove
> all but the last 4 digits in a column of numbers

Reply to this Message