How can I convert all Caps to first letter caps in Excel?
 

I have a large worksheet in a database I am building and am transporting some
files that are all caps. Is there any possible way that I can change it to
small font except for the first letter of the word? Eventually I am going to
be creating mailing lists and feel it would be more presentable in this type
of format.

Hi

Have a look at the PROPER function

--
Andy.


"Fenljp26" wrote in message
...
I have a large worksheet in a database I am building and am transporting
some
files that are all caps. Is there any possible way that I can change it
to
small font except for the first letter of the word? Eventually I am going
to
be creating mailing lists and feel it would be more presentable in this
type
of format.

Try this:
http://www.officearticles.com/excel/...ft_exce l.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Fenljp26" wrote in message
...
I have a large worksheet in a database I am building and am transporting
some
files that are all caps. Is there any possible way that I can change it
to
small font except for the first letter of the word? Eventually I am going
to
be creating mailing lists and feel it would be more presentable in this
type
of format.

Thanks Andy, saves alot of time..

"Andy B" wrote:

Hi

Have a look at the PROPER function

--
Andy.


"Fenljp26" wrote in message
...
I have a large worksheet in a database I am building and am transporting
some
files that are all caps. Is there any possible way that I can change it
to
small font except for the first letter of the word? Eventually I am going
to
be creating mailing lists and feel it would be more presentable in this
type
of format.

Anne-
Thanks, saved me alot of time
J

"Anne Troy" wrote:

Try this:
http://www.officearticles.com/excel/...ft_exce l.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Fenljp26" wrote in message
...
I have a large worksheet in a database I am building and am transporting
some
files that are all caps. Is there any possible way that I can change it
to
small font except for the first letter of the word? Eventually I am going
to
be creating mailing lists and feel it would be more presentable in this
type
of format.

Thanks for the feedback!

--
Andy.


"Fenljp26" wrote in message
...
Thanks Andy, saves alot of time..

"Andy B" wrote:

Hi

Have a look at the PROPER function

--
Andy.


"Fenljp26" wrote in message
...
I have a large worksheet in a database I am building and am transporting
some
files that are all caps. Is there any possible way that I can change
it
to
small font except for the first letter of the word? Eventually I am
going
to
be creating mailing lists and feel it would be more presentable in this
type
of format.