I have about 5000 product code entries, but they all need changing, i
want to get rid of the last two digits:

e.g 01234500 to 012345

Is there a way to do this for all the entries quickly?


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