Should be a simple answer, but cannot figure it out. Column A1:A10 shows
1,2,3,4...10 respectively. Column B has text in each cell adjacent to
1,2,3,4...10. If a cell in column B has no text, I want the adjacent cell in
column A to show no number at all. I want the cell to be blank. But if there
is text that goes back into the cell, I want it to reflect the 1,2,3,4...(the
number it should be). Hope it makes sense. Thanks again.