| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete part of a cell
I have a spreadsheet with 10,000 rows with this information;
Rows look like this, R1 Ontime: 100.00% R2 711 *OEM1676EN R3 Tot R4 Ontime: 92.00% R5 129 D317002 I need to find all rows that contain "Ontime:" and remove the word "Ontime:" to leave the percentage in that cell only. This is all in one column. Or, can I just copy the percentage part to another cell? Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does it take so long to delete a part of table? | Excel Discussion (Misc queries) | |||
| delete part of text from a cell | Excel Worksheet Functions | |||
| How do I delete only part of the data in a row of cells? | Excel Worksheet Functions | |||
| How do I delete part of a text string in every cell it appears in | Excel Discussion (Misc queries) | |||
| Delete part of a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
