| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find within range & Replace with Blank Value
I have two questions, PLEASE HELP:
1) I need to find & replace values within certain columns only, for the entire workbook. I've tried selecting those columns before pressing CTRL + H, but it still replaces values outside of the range. I've also tried each setting of the advanced options, nothing works. 2) I need to replace values with a blank cell, I've tried "", and that actually places "" in the cell, I also don't want to just enter a space, because that's not actually blank, the space would be a character. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find the next blank cell in a range? | Excel Worksheet Functions | |||
| How Do I find/replace a blank cell with a formula? | Excel Worksheet Functions | |||
| How to find and replace blank space (x) in John Smithx in Excel? | Excel Discussion (Misc queries) | |||
| How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
| find the first blank cell in a range and return me it's position | Links and Linking in Excel | |||
Threaded Mode
