Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removal of characters from a range of cells
How can you remove the last two characters from a range of cells in Excel?
|
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Formula help for using a range of cells! | Excel Worksheet Functions | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |