#1   Report Post  
Posted to microsoft.public.excel.misc
oldguywithbadeyes
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to have cell C8 contain contents of Cell G(formula) Skip Excel Discussion (Misc queries) 1 April 25th 06 02:38 AM
Selectively Clearing cell contents jdd Excel Worksheet Functions 2 April 22nd 06 04:06 AM
Returning Cell Value if someone deletes the contents of a cell mmc308 Excel Worksheet Functions 4 March 31st 06 06:41 PM
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
Modify Row & Cell Contents based upon Cells Values bpat1434 Excel Worksheet Functions 0 November 7th 04 04:31 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"