great, thanks
"Dave R." wrote:
You may have understood it (proper) properly (?) but you used it improperly.
Highlighting a column of data and entering a formula on top of it wont do
anything but overwrite the contents of the top cell which should make it
blatantly obvious that it's not the right way to do it since you're over
writing the data you want the function to work on.
This is why you use the formula in a separate range and reference the cells
containing the data you want to do work on.
"linpengie" wrote in message
...
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!
|