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
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
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
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
On Tue, 2 May 2006 14:07:02 -0700, oldguywithbadeyes
<[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks