| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and replace issue
How does one search and replace blank cells with a "."?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 "."? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel find and replace issue | Excel Discussion (Misc queries) | |||
| Excel find and replace issue | Excel Discussion (Misc queries) | |||
| Search and Replace | Excel Discussion (Misc queries) | |||
| Search and Replace | New Users to Excel | |||
| Search and replace | Excel Worksheet Functions | |||
Linear Mode
