Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modify cell contents
I have many part numbers that end with |01. I want to delete the |01 in each
cell without doing them individually. They are all in the same column. The numbers look like this; 0993616|01, 4657-02|01, 408-Q|01. Thanks -- meagain |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modify cell contents
Use Edit==Replace
Find what: |01 Replace with: <nothing here Replace All "oldguywithbadeyes" wrote: I have many part numbers that end with |01. I want to delete the |01 in each cell without doing them individually. They are all in the same column. The numbers look like this; 0993616|01, 4657-02|01, 408-Q|01. Thanks -- meagain |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modify cell contents
Select all cells in question.
DataText to ColumnsDelimited byOtherEnter a pipe(|) and Next Select the right-most column and "do not import"(skip). Finish Gord Dibben MS Excel MVP On Tue, 2 May 2006 14:07:02 -0700, oldguywithbadeyes wrote: I have many part numbers that end with |01. I want to delete the |01 in each cell without doing them individually. They are all in the same column. The numbers look like this; 0993616|01, 4657-02|01, 408-Q|01. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to have cell C8 contain contents of Cell G(formula) | Excel Discussion (Misc queries) | |||
Selectively Clearing cell contents | Excel Worksheet Functions | |||
Returning Cell Value if someone deletes the contents of a cell | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions |