you are the best

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

Andy.

"roddtx" wrote
in
message ...

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


--
roddtx

------------------------------------------------------------------------
roddtx's Profile:
http://www.excelforum.com/member.php...o&userid=32571
View this thread:
http://www.excelforum.com/showthread...hreadid=523694



--
roddtx
------------------------------------------------------------------------
roddtx's Profile: http://www.excelforum.com/member.php...o&userid=32571
View this thread: http://www.excelforum.com/showthread...hreadid=523694