Text (blank) in pivot table cell

[Guest]

Hi There,
I am running Excel 2000. I've created a pivot table from
source data that has a comments column with a general
format. Some cells have text data, others are blank. When
this column is included in a pivot table, the cells which
were blank show the message (blank). Is there a way to
get it to just display a space?

Under Pivot table options, I do have the option 'For empty
cells' checked. It shows a space in the value to
display.

I appreciate your suggestions! Sue

 

[Dave Peterson]

You could put a spacebar in your raw data, but I hate to see those. It can mess
up formulas like:

=if(a1="",....)
You could change these to:
=if(trim(a1)="",....)

I like to put this formula in those cells:
=""

I can see it in the formula bar and (I hope) that it serves as a reminder why I
did it.

Putting an apostrophe would work, too (')--but those can be more difficult to
notice.

=====
One way of filling those blank cells:
Select your range
edit|goto|special|blanks
type =""
hit ctrl enter

and then refresh that pivottable.