| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting from within a cell
I have a column of 5000 part numbers. In each cell contains a part number.
The part numbers looks like this... 1240-00-101-1234 1240-00-102-1234 1240-00-103-1234 I am trying to delete from each cell the dash - and the first four numbers of the part number so it will look like this 001011234 001021234 001031234 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
| cell color index comparison | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
