There is a difference between an empty cell, which you would test for with two double quotes ( "" ) and a cell with a single space in it which you would test for with double quote, space, double quote ( " " ).
Which do you need?
That said, I don't really understand what the formula is intended to achieve. Please spell it out (in words).
Bookmarks