You could use the following formula - if the data is in column B enter the
formula in the next column

=LEFT(B5,LEN(B5)-2)


"KopRed" wrote in message
...
How can you remove the last two characters from a range of cells in Excel?