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