| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete only part of the data in a row of cells?
My column B contains a series of numbers with a space then a part#. All I
want to keep in this row is the part#, I need to get rid of the numbers before it. Help? Here is an example: Cell B46 contains "205 234457-B22", cell B47 contains "206 332558-B21", etc...I need to figure out how to delete 205, 206, etc from these cells as there are thousands of them and I don't want to do |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Only Empty Cells AFTER Cells with Data | Excel Worksheet Functions | |||
| how to delete contents of cells having specific data | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Threaded Mode
