sponsored ads

how to convert small letter to capital letter in excel?

sponsored ads

Topic:  Office Microsoft Office Excel   Product:  other   Related Artilces:  convert small alphabet captil wordpad   convert small capital autocad   convert small letter as2.0
Insistshary

I'm doing my job now.However, i came across a problem that i can't convert small letter to capital letter in excel, who knows what's the reason? can you help me to finish this? thank you

Asked Aug, 04 2010
add comment•flag 

sponsored ads

answer this question

1 answers

Football2010

Example:
cell A1: MINERVA
cell B1, type this =LOWER(A1)
will result minerva in B1

cell C1, type this =UPPER(B1)
will result MINERVA in C1

cell D1, type this =PROPER(C1)
will result Minerva in cell D1

Hope this helps and Good luck.

Answered Aug, 05 2010
add comment|flag 
vote up 1 vote down
check

Evening

Example:
cell A1: MINERVA
cell B1, type this =LOWER(A1)
will result minerva in B1

cell C1, type this =UPPER(B1)
will result MINERVA in C1

cell D1, type this =PROPER(C1)
will result Minerva in cell D1

Hope this helps and Good luck.

Answered Sep, 23 2010
vote up 0 vote down

Jmorgan

Try Format, Change Case or Shift+F3 to toggle between options. Also on Format Fonts, Small Caps give you the Large Capital and the rest of the word in Small Capitals. Depending on the effect you are after. Answered Dec, 15 2010
vote up 0 vote down

Lakers

 

Hi,you can make it with the Module item on the insert menu in VBA to realize it:

Sub ChangeCase()
    Dim Rng As Range
    On Error Resume Next
    Err.Clear
    Application.EnableEvents = False
    For Each Rng In Selection.SpecialCells(xlCellTypeConstants, _
             xlTextValues).Cells
        If Err.Number = 0 Then
 

Answered Nov, 11 2010
vote up 0 vote down

Search for Related Topics

mssql convert small letter capital   convert small letter capital c#   convert small letters capital letter excel2007   capital letter jpeg small letter jpeg converter   shortcut convert small capital win7   convert small letters capital letters outlook   photoshop cs3 capital letter problem   converting small letter capital code qtp   photo converter small letter   convert smallletter capital letter autocad   convert letters short capital inexcel   convert gmail username capital letters

Related Unresolved Questions

more»
Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
 Create one

Options

sponsored ads

Download related software from AFC

RAC1 to the letter 1.3

Last Updated: Jul 4, 2011
License:
Filesize: 131KB

Continue to downloadPower by Afreecodec.com