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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how do i use excel to replace blank cells with the number 9 (https://www.excelbanter.com/new-users-excel/201684-how-do-i-use-excel-replace-blank-cells-number-9-a.html)

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

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

Don Guillett

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

A simple way is to select the area desirededitreplaceleave blankreplace
with 9enter...
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"t" wrote in message
...
how do i use excel to replace blank cells with the number 9

All times are GMT +1. The time now is 12:52 AM.