Home |
Search |
Today's Posts |
#1
|
|||
|
|||
deleting certain text from cells
does anyone know a way or have a macro that will delete certain text from a
sheet of cells. i need to get rid of all of 'N/A' cells in a list, and i am not sure how to do this. |
#2
|
|||
|
|||
Assuming you have formulas that return these, select the range,hit F5, click
special and select formulas and uncheck everything but errors, click OK and do editclearall (or delete them) Regards, Peo Sjoblom "BLW" wrote: does anyone know a way or have a macro that will delete certain text from a sheet of cells. i need to get rid of all of 'N/A' cells in a list, and i am not sure how to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Large amount of text in cells - Problem text.xls (0/1) | Excel Discussion (Misc queries) | |||
Clicking cells on sheet creates Text Box. How do I turn this off? | Excel Discussion (Misc queries) | |||
How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions |