that's the function I tried to use and it didn't work, unless I understood it
improperly. What I did was highlight the whole column then attempt to apply
the function. It didn't work.
so now what?
lin

"Ramakrishnan Rajamani" wrote:

From what I understand, it looks like you are trying to convert the initial
letters (seperated by spaces) to capitals. There is an inbuilt function
=Proper(text) which could be tried out.

"linpengie" wrote:

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!