ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I cant seem to figure out how to use Proper in excel. The help op. (https://www.excelbanter.com/excel-discussion-misc-queries/1867-i-cant-seem-figure-out-how-use-proper-excel-help-op.html)

deborahpib

I cant seem to figure out how to use Proper in excel. The help op.
 
I keep trying to figure out how to change data in excel so that instead of
all CAPS, it will have the first letter be capatalized and the rest small
cap. (its names and addresses that I'm trying to merge to a word doc.)

The help option is 0 help. It errors and will not tell me how to change the
whole doc at all.

Frank Kabel

Hi
see:
http://www.cpearson.com/excel/case.htm

--
Regards
Frank Kabel
Frankfurt, Germany

deborahpib wrote:
I keep trying to figure out how to change data in excel so that
instead of all CAPS, it will have the first letter be capatalized and
the rest small cap. (its names and addresses that I'm trying to merge
to a word doc.)

The help option is 0 help. It errors and will not tell me how to
change the whole doc at all.





All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com