You can use the RIGHT function to pull this data out of a cell, as
such:

=RIGHT(C2,4)

this will pull the right-most 4 characters from cell C2.

Is this what you are looking for?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=391794