| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can i delete the last 3 characters in each cell in a column in 1 .
I have a column of names followed by a number. Obviously the names are of
different lengths but the numbers are consistent, so i need to remove say 8 chars from the right of each filed in the column. I'm sure I have done this before but can't remember how! D'oh! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| How do I transpose Comma Separated Data in each cell and delete t. | Excel Discussion (Misc queries) | |||
| limit number of characters in a cell | Excel Discussion (Misc queries) | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| #### error if cell has more than 255 characters | Excel Discussion (Misc queries) | |||
Threaded Mode
