| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I DELETE NUMBERS IN A COLUMN out of each cell
I have a list of part numbers in a column, over 5000, and I need to change it
while keeping other information in tact. For example 1025-00-128-5463 (Each of these numbers are in a cell which totals 1025-00-255-5656 5000. They are listed in a column.) 1025-00-233-5666 I need to delete the first four numbers and all the dash marks so they will look like this 001285463 002555656 002335666 If I tried to do this individually I would waste a lot of time. Please help and remember I am new to this program. Any help would be sincerely appreciated Thanks Dave |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
HOW DO I DELETE NUMBERS IN A COLUMN out of each cell
=substitute(RIGHT(A1,11),"-","")
and copy down -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Completely Confused" <Completely wrote in message ... I have a list of part numbers in a column, over 5000, and I need to change it while keeping other information in tact. For example 1025-00-128-5463 (Each of these numbers are in a cell which totals 1025-00-255-5656 5000. They are listed in a column.) 1025-00-233-5666 I need to delete the first four numbers and all the dash marks so they will look like this 001285463 002555656 002335666 If I tried to do this individually I would waste a lot of time. Please help and remember I am new to this program. Any help would be sincerely appreciated Thanks Dave |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
HOW DO I DELETE NUMBERS IN A COLUMN out of each cell
If you want to actually alter the current values,
try this 2-step process: Select your column of values From the Excel main menu: <edit<replace Find what: ????-00- Replace with: '00 <-that's an apostrophe and 2 zeros Click [Replace all] Leave the Replace window open and set Find what: - Replace with: (clear this field) Click [Replace all] Does that help? *********** Regards, Ron XL2002, WinXP "Completely Confused" wrote: I have a list of part numbers in a column, over 5000, and I need to change it while keeping other information in tact. For example 1025-00-128-5463 (Each of these numbers are in a cell which totals 1025-00-255-5656 5000. They are listed in a column.) 1025-00-233-5666 I need to delete the first four numbers and all the dash marks so they will look like this 001285463 002555656 002335666 If I tried to do this individually I would waste a lot of time. Please help and remember I am new to this program. Any help would be sincerely appreciated Thanks Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
