If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 how to change small letters to capital letters
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## how to change small letters to capital letters

#1
May 28th 07, 07:13 AM posted to microsoft.public.excel.misc
 HOW TO CHANGE external usenet poster Posts: 1
how to change small letters to capital letters

how to change small letters into capital letters or capital letters into
small letters.

regards,
BALU
#2
May 28th 07, 07:31 AM posted to microsoft.public.excel.misc
 Steve T[_2_] external usenet poster Posts: 3
how to change small letters to capital letters

Check the Microsoft Excel help for the UPPER and LOWER functions.

Hope this helps.

"HOW TO CHANGE" wrote:

>
> how to change small letters into capital letters or capital letters into
> small letters.
>
>
> regards,
> BALU

#3
May 28th 07, 07:52 AM posted to microsoft.public.excel.misc
 Shailesh Shah external usenet poster Posts: 17
how to change small letters to capital letters

Hi Balu,

You may find several methods\free add-ins via google search and also check

below site.

"change cell case" from below site

http://in.geocities.com/shahshaileshs/

Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/

"HOW TO CHANGE" wrote:

>
> how to change small letters into capital letters or capital letters into
> small letters.
>
>
> regards,
> BALU

#4
May 29th 07, 09:19 PM posted to microsoft.public.excel.misc
 austuni external usenet poster Posts: 4
how to change small letters to capital letters

Hi Balu,
formula: to change from capital letters to small letters =lower()
to change from small letters to capital letters =upper()
(put the cell in the () e.g. =lower(A1)

Austuni
"HOW TO CHANGE" wrote:

>
> how to change small letters into capital letters or capital letters into
> small letters.
>
>
> regards,
> BALU

#5
May 30th 07, 01:12 AM posted to microsoft.public.excel.misc
 Roger Govier external usenet poster Posts: 2,886
how to change small letters to capital letters

Hi
=PROPER(A1)
which would change "this" to "This"

--
Regards

Roger Govier

"HOW TO CHANGE" <HOW TO > wrote in
message ...
>
> how to change small letters into capital letters or capital letters
> into
> small letters.
>
>
> regards,
> BALU

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post how do i turn all letters into capital letters? KeithT Excel Discussion (Misc queries) 3 May 11th 07 02:13 PM how to change existing column to capital letters fredg Excel Discussion (Misc queries) 3 January 16th 07 05:24 PM How do change a column of data in capitol letters to small letters Barb P. Excel Discussion (Misc queries) 6 November 15th 06 06:17 PM How do I change a column of cells to all capital letters? morpattyjo Excel Worksheet Functions 4 March 13th 05 07:59 PM Auto change font to 'capital letters' Anthony Excel Worksheet Functions 3 February 12th 05 03:10 PM

All times are GMT +1. The time now is 09:30 PM.