i would like to have excel basically test a cell for data. if its empty, i would like it to write a "0" to another cell. if there is data, i would like it to write a "1" to another cell. btw, the info. in the cell is text. any help would be greatly appreciated.
thank you
thank you