Use the PROPER() function.

If the string "ALL CAPS" was located in cell A1, =PROPER(A1) will output
"All Caps"


--
Regards,
Dave


"Miss Dedly" wrote:

hello again

this problem im being told has no simple solution but im going to ask anyway
this database we just bought came all in CAPS, however this information
(including names, addresses, company names etc..) needs to be in the correct
case for mailing purposes and formal letters

does anyone have a solution or a tip or trick or anything that is less
painful then retyping everything?

THANKS IN ADVANCE!!!