Search and replace issue
 

How does one search and replace blank cells with a "."?

Search and replace issue
 

Select the range to fix
edit|replace
what: (leave blank)
with: .
replace all

Excel will only modify cells in the used range, though.

pickwickian wrote:

How does one search and replace blank cells with a "."?

--

Dave Peterson

Search and replace issue
 

Hi,

If I understand you correctly.
Place "." in a cell and copy it
Then select the area of interest
Then tap F5
Select special
Check Blanks
OK
Right click on one of the selected cells and select Paste
Then tap the up arrow

HTH
Martin


"pickwickian" wrote in message
...
How does one search and replace blank cells with a "."?