Why not use a macro to change all to all caps or all to lower FIRST

--
Don Guillett
SalesAid Software

"Kal321" wrote in message
...
Hi.
I posted this last week to the wrong group I think so appologies for the
cross post. Anyway the problem is:

I have a very large amount of data extracted from an external db of which
some entrys are all caps, and the majority of records are caps and lower
case. I want to sort so that the caps records are either all first, or all
last so that I can then go back into the external db, and correct those
records. It would be possible to go through this manually but that would
take
a very long time to complete as currently it stands at six workbooks with
2000+ pages in each. I have tried using the case sensative option under
the
data search but this doesnt seem to have any effect.
Anyone got any suggestions as to how to resolve this?
Thanks in advance
K
All the records are in English, and despite using teh