Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |