Removal of characters from a range of cells

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

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" <[email protected]> wrote in message
news:[email protected]...
> How can you remove the last two characters from a range of cells in Excel?

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" <[email protected]> wrote in message
news:[email protected]...
> How can you remove the last two characters from a range of cells in Excel?

Thanks! Perfect.

"James" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > How can you remove the last two characters from a range of cells in Excel?
>
>
>