I have a number of large spredsheets made up from data imported from an
external db. One column in particular consists of records some of which are
all capitals whilst others are a combination of upper & lower case. I want to
sort so that all the entrys with capitals are grouped together along with teh
information in teh other columns. I have tried using teh case sensitive
option and it doesnt appear to do anything. The files themselves are to large
to go through manually. Anyone ggot any suggestions as how to fix this?
Thanks in advance