Hi SCW

Another way to extract the last 2 digits would be to use this formula
in the cell next to the numbers you want to change

=IF(LEN(A3)=6,MID(A3,5,2),IF(LEN(A3)=7,MID(A3,6,2) ,MID(A3,7,2)))

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=391238