I will try this and see what happens. If anyone has other solutions, I'd be
much obliged
lin

"Dave R." wrote:

The easiest way (you asked for it!) would be to use a 'helper' column with
the formula

=proper(a1)

and copying the formula down until all your columns data is in this new
column in proper case.
Then, copy this entire column and paste special (as values) over the range
of the original, upper-case data. Make a backup just to be safe before you
do this.


"linpengie" wrote in message
...
I have imported data from an FMPro Database which is already in Title Case
into Excel. When it imported, it became Upper case. since this data is
to
be used in a mail merge I would prefer to be able to change the case in
the
entire column to Title Case. I believe my problem could be solved with a
formula, but can't figure out how to make it work. I checked Knowledge
Base
and Help but can't find what I need. As I'm a novice with formulas I need
an
EASY solution. Help!