Modify cell contents

  • Thread starter oldguywithbadeyes
  • Start date
O

oldguywithbadeyes

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
 
G

Gord Dibben

Select all cells in question.

Data>Text to Columns>Delimited by>Other>Enter a pipe(|) and Next

Select the right-most column and "do not import"(skip).

Finish


Gord Dibben MS Excel MVP
 
Top