how do i use excel to replace blank cells with the number 9

D

Don Guillett

A simple way is to select the area desired>edit>replace>leave blank>replace
with 9>enter...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get Rid of the Circumflex Accent (Caret) 2
Excel Concatenate with line breaks but ignore blank cells 3
Excel Sumproduct 0
Zero problem with blank cell after automated data transfer 3
Find Replace Wildcard 9
Graphing Question: Blank Lines Problem ? 2
Select max value from 9 cells, copy cell col heading to other cell 6
Nested IF that will ignore blank (empty) cells 9

Top