Empty Cells

[bigdon]

I export data from a program called OpenView Service Desk into a
spreadsheet. This spreadsheet is then imported into Access and queries
performed on the imported data. This data is then copied and pasted
into a different spreadsheet where calculations are performed. In one
particular spreadsheet there are 2 columns, one complete with data (no
empty cells) and the other which may contain empty cells. I need to
count the number of "empty cells" however the problem is, these cells,
although they appear empty, are not. I need to but cannot find the
content(s) of this cell(s). How do I figure out what "hidden"
character is within this cell(s)?

The point is to eventually calculate the empty cells in column B
without having to specify a certain range (B:B as opposed to B1:B150),
I simply want to know how many empty cells are in column B without
excel returning every blank cell in the column. For example, where
column A has data, count the empty cells in column B (with this
"hidden" data in the cell, every formula I have tried simply returns
0). I am not a programmer so I would prefer to stick to functions if
possible. I have used variations of count/counta/countif, sum/sumif/
sumproduct, nested if functions and ISBLANK with no success.

 

[Peo Sjoblom]

Use

=CODE(A2)

where A2 is a cell with the invisible character, you can also press F2, then
shift + left arrow, then Ctrl + C to copy the character. Then do ctrl + H,
click in the find what box and press ctrl + V, then leave the replace with
box blank and replace them