This information was created from data extracted from an external db. That db
is the product of an very old in-house db and 10 years worth of work. As a
result very old records were created or imported in a capitalised form. I
want to be able to identify the capitalised records so that I can then send
staff into the databse to conduct clean up, by overlaying from a 3rd party
subscription database. If I were to change them to a lowerc case I would have
no other way of identifying which records were the ones requiring clean up.

"Don Guillett" wrote:

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