Found another way as well

=LEFT(A2, LEN(A2)-2) Removes last two characters from contents of A2
=RIGHT(A3, LEN(A3)-8) Removes first 8 characters from A3

Thank heaps

go team


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=483692