Removal of characters from a range of cells

[KopRed]

How can you remove the last two characters from a range of cells in Excel?

 

[James]

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)

 

[CLR]

You've received a good answer assuming your data might be of inconsistant
string lengths........however, if your data is consistant in nature, like
some part numbers, etc, you might can use either "Find > Replace" or " Data

Text to columns" to perform the action all within the same column.

If you are interested, post back with a sample of your data in the post (not
attached) and someone will provide more details.

Vaya con Dios,
Chuck, CABGx3

 

[KopRed]

Thanks! Perfect.

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)