View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default 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 "."?