Trailing spaces in Pivot tables

G

Guest

Does anyone know why 'abc' and 'abc ' appear as two different values in
pivot table page, row, or column fields? Is there a configuration setting to
control this? The same values appear only once in the filter list in a
filtered data table, and behave per ANSI 92 (ie 'abc'='abc ') in Microsoft
query group and criteria statements.
thanks in advance
Baffled in Bury
 
T

Tom Ogilvy

to the best of my knowledge, there isn't. Pivot Tables are not using SQL to
the best of my knowledge. In a cell, your example is false.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel pivot fields and trailing spaces 1
Excel problem with trailing spaces 1
Pivot tables 1
Pivot tables 3
List any duplicates once - no pivot tables 2
Calculated Item in Pivot table 1
% of subtotal in pivot tables 1
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1

Top