Hi all,

I'm still battling with a problem.

I have a pivot table which is counting blank cells from the range of data that the pivot table is reading from.

It appears some of the cells have spaces in them so they appear blank in the data range but the pivot table is counting them.

Is their a way I can clear these cells with spaces in, so the pivot table reads them as blank?

Many thanks,

Nicko