how do i use excel to replace blank cells with the number 9
D Don Guillett Sep 8, 2008 #2 A simple way is to select the area desired>edit>replace>leave blank>replace with 9>enter...
