Blank Cells

D

daphoenix

if there are blank cells in a range which i would specify i want to put in
the text "-". what kind of code would i use?

thanks
 
P

Peo Sjoblom

Select the range, press F5, click special and select blanks, press enter.
type
- and press ctrl + enter instead of enter

Note that if you have numbers in the other cells it is not a good design
using text as well


Regards,


Peo Sjoblom
 
Top