Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 28th 07, 07:13 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 1
Default how to change small letters to capital letters

dear sir/madam,

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


regards,
BALU

  #2   Report Post  
Old May 28th 07, 07:31 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 3
Default 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:

dear sir/madam,

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


regards,
BALU

  #3   Report Post  
Old May 28th 07, 07:52 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 17
Default how to change small letters to capital letters

Hi Balu,

You may find several methods\free add-ins via google search and also check
back later for your post.

To find within excel, you may download Google search addins by Ron from
below site.

http://www.rondebruin.nl/Google.htm

BTW in case you want to use addins, you may download my free com-addins
"change cell case" from below site

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

Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)




"HOW TO CHANGE" wrote:

dear sir/madam,

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


regards,
BALU

  #4   Report Post  
Old May 29th 07, 09:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 4
Default 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:

dear sir/madam,

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


regards,
BALU

  #5   Report Post  
Old May 30th 07, 01:12 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,886
Default how to change small letters to capital letters

Hi
In addition to the responses you have already received, don't forget
=PROPER(A1)
which would change "this" to "This"

--
Regards

Roger Govier


"HOW TO CHANGE" <HOW TO wrote in
message ...
dear sir/madam,

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


regards,
BALU





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 06: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 07:17 PM
How do I change a column of cells to all capital letters? morpattyjo Excel Worksheet Functions 4 March 13th 05 08:59 PM
Auto change font to 'capital letters' Anthony Excel Worksheet Functions 3 February 12th 05 04:10 PM


All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017