How do I distinguish between upper and lower case with pivot tabl.

G

Guest

How do I distinguish between upper and lower case items when creating a pivot
table, e.g. a list of warehosue names which have combinations of both upper
and lower case, lower case being one type of warehouse and the upper case
ones representing a different type
 
J

Jason Morin

What you could do is add a column to the original table
that attaches a "1" in front of every warehouse name whose
first character is upper case.

=IF(CODE(LEFT(A2))<91,1&A2,A2)

And fill down. Then use this new column in your pivot
table.

HTH
Jason
Atlanta, GA
 

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

Counting Upper and Lower case chars in a Cell 7
vlookup -- Upper case and Lower case text 1
IN EXCEL, HOW DO I ALTER LOWER CASE TO UPPER NOT OVERTYPING 1
Changing file in all upper case to upper and lower case 15
How do I Change Case or tOGGLE cASE in Excel? 1
upper case lower case 0
How do I change existing text from lower case to upper case 2
Countif with upper and lower case 3

Top